ambitious-rose-93174
06/08/2022, 3:02 PM[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):
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?ambitious-rose-93174
06/09/2022, 8:57 AMfierce-monkey-46092
03/29/2023, 6:44 AM