hi, I'm trying to profile a table in an Oracle dat...
# troubleshoot
a
hi, I'm trying to profile a table in an Oracle database. This table has numeric, date, and varchar fields. I'm just enabling the profiling without any additional configuration. During the profiling run, I get some warnings at the start of the run of the type:
Copy code
[2022-06-08 16:19:17,123] WARNING  {great_expectations.dataset.sqlalchemy_dataset:1814} - No recognized sqlalchemy types in type_list for current dialect.
Later, I get the following non-fatal exceptions (there are many of them; I'm assumin one for each 'problematic' field):
Copy code
During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/home/marco/tmp/datahub/.env/lib/python3.9/site-packages/datahub/utilities/sqlalchemy_query_combiner.py", line 246, in _sa_execute_fake
    handled, result = self._handle_execute(conn, query, args, kwargs)
  File "/home/marco/tmp/datahub/.env/lib/python3.9/site-packages/datahub/utilities/sqlalchemy_query_combiner.py", line 211, in _handle_execute
    if not self.is_single_row_query_method(query):
  File "/home/marco/tmp/datahub/.env/lib/python3.9/site-packages/datahub/ingestion/source/ge_data_profiler.py", line 218, in _is_single_row_query_method
    query_columns = get_query_columns(query)
  File "/home/marco/tmp/datahub/.env/lib/python3.9/site-packages/datahub/utilities/sqlalchemy_query_combiner.py", line 114, in get_query_columns
    return list(query.columns)
AttributeError: 'str' object has no attribute 'columns'
[2022-06-08 16:39:36,731] ERROR    {datahub.utilities.sqlalchemy_query_combiner:250} - Failed to execute query normally, using fallback: SELECT field  
FROM XXXX.YYYY 
WHERE 1 = 1 AND field IS NOT NULL
AND ROWNUM <= 20
Traceback (most recent call last):
  File "/home/marco/tmp/datahub/.env/lib/python3.9/site-packages/datahub/utilities/sqlalchemy_query_combiner.py", line 111, in get_query_columns
    inner_columns = list(query.inner_columns)
AttributeError: 'str' object has no attribute 'inner_columns'
Eventually the profiling ends and the Stats tab on the UI is populated partially. All the numeric fields have these stats set as null: min, max, mean, median, std dev Any idea on what's the issue here?
one more info: I'm using the python library version 0.8.35
f
hey @ambitious-rose-93174 did you find the solution to this?