xueyun0512 opened a new issue, #33033: URL: https://github.com/apache/superset/issues/33033
### Bug description I have hive tables connected using impyla. Somes columns are timestamp and date. It works fine in SQL LAb but when creating dashboard (time serie bar chart for instance). The column evttime is a timestamp format. I got this error message: `Apache Impala Error Error while compiling statement: FAILED: ParseException line 1:31 cannot recognize input near 'AS' '__timestamp' ',' in selection target` ### Screenshots/recordings  ### Superset version master / latest-dev ### Python version 3.10 ### Node version I don't know ### Browser Chrome ### Additional context Here is logs from superset.log: `Query SELECT TRUNC(evttime, 'MI') AS __timestamp, SUM(CASE WHEN result = 1 THEN 1 ELSE 0 END) / COUNT(*) AS success_rate FROM superset_mickey.impyla_test GROUP BY TRUNC(evttime, 'MI') ORDER BY success_rate ASC LIMIT 10000 on schema superset_mickey failed Traceback (most recent call last): File "/users/mickey/.conda/envs/superset/lib/python3.10/site-packages/superset/connectors/sqla/models.py", line 1761, in query df = self.database.get_df( File "/users/mickey/.conda/envs/superset/lib/python3.10/site-packages/superset/models/core.py", line 677, in get_df self.db_engine_spec.execute(cursor, sql_, self) File "/users/mickey/.conda/envs/superset/lib/python3.10/site-packages/superset/db_engine_specs/impala.py", line 107, in execute raise cls.get_dbapi_mapped_exception(ex) from ex File "/users/mickey/.conda/envs/superset/lib/python3.10/site-packages/superset/db_engine_specs/impala.py", line 105, in execute cursor.execute_async(query) File "/users/mickey/.conda/envs/superset/lib/python3.10/site-packages/impala/hiveserver2.py", line 443, in execute_async self._execute_async(op) File "/users/mickey/.conda/envs/superset/lib/python3.10/site-packages/impala/hiveserver2.py", line 462, in _execute_async operation_fn() File "/users/mickey/.conda/envs/superset/lib/python3.10/site-packages/impala/hiveserver2.py", line 438, in op op = self.session.execute(self._last_operation_string, File "/users/mickey/.conda/envs/superset/lib/python3.10/site-packages/impala/hiveserver2.py", line 1324, in execute return self._operation('ExecuteStatement', req, False) File "/users/mickey/.conda/envs/superset/lib/python3.10/site-packages/impala/hiveserver2.py", line 1244, in _operation resp = self._rpc(kind, request, safe_to_retry) File "/users/mickey/.conda/envs/superset/lib/python3.10/site-packages/impala/hiveserver2.py", line 1181, in _rpc err_if_rpc_not_ok(response) File "/users/mickey/.conda/envs/superset/lib/python3.10/site-packages/impala/hiveserver2.py", line 867, in err_if_rpc_not_ok raise HiveServer2Error(resp.status.errorMessage) impala.error.HiveServer2Error: Error while compiling statement: FAILED: ParseException line 1:31 cannot recognize input near 'AS' '__timestamp' ',' in selection target Unserializable object Empty DataFrame Columns: [] Index: [] of type <class 'pandas.core.frame.DataFrame'> Traceback (most recent call last): File "/users/mickey/.conda/envs/superset/lib/python3.10/site-packages/superset/views/error_handling.py", line 100, in wraps return f(self, *args, **kwargs) File "/users/mickey/.conda/envs/superset/lib/python3.10/site-packages/superset/utils/log.py", line 303, in wrapper value = f(*args, **kwargs) File "/users/mickey/.conda/envs/superset/lib/python3.10/site-packages/superset/utils/cache.py", line 183, in wrapper return f(*args, **kwargs) File "/users/mickey/.conda/envs/superset/lib/python3.10/site-packages/superset/views/utils.py", line 419, in wrapper return f(*args, **kwargs) File "/users/mickey/.conda/envs/superset/lib/python3.10/site-packages/superset/views/base.py", line 178, in wraps return f(self, *args, **kwargs) File "/users/mickey/.conda/envs/superset/lib/python3.10/site-packages/superset/views/core.py", line 341, in explore_json return self.generate_json(viz_obj, response_type) File "/users/mickey/.conda/envs/superset/lib/python3.10/site-packages/superset/views/core.py", line 191, in generate_json return self.get_raw_results(viz_obj) File "/users/mickey/.conda/envs/superset/lib/python3.10/site-packages/superset/views/core.py", line 161, in get_raw_results return json_error_response(payload=payload, status=400) File "/users/mickey/.conda/envs/superset/lib/python3.10/site-packages/superset/views/error_handling.py", line 83, in json_error_response json.dumps(payload, default=json.json_iso_dttm_ser, ignore_nan=True), File "/users/mickey/.conda/envs/superset/lib/python3.10/site-packages/superset/utils/json.py", line 210, in dumps results_string = simplejson.dumps( File "/users/mickey/.conda/envs/superset/lib/python3.10/site-packages/simplejson/__init__.py", line 395, in dumps **kw).encode(obj) File "/users/mickey/.conda/envs/superset/lib/python3.10/site-packages/simplejson/encoder.py", line 298, in encode chunks = self.iterencode(o) File "/users/mickey/.conda/envs/superset/lib/python3.10/site-packages/simplejson/encoder.py", line 379, in iterencode return _iterencode(o, 0) File "/users/mickey/.conda/envs/superset/lib/python3.10/site-packages/superset/utils/json.py", line 127, in json_iso_dttm_ser return base_json_conv(obj) File "/users/mickey/.conda/envs/superset/lib/python3.10/site-packages/superset/utils/json.py", line 107, in base_json_conv raise TypeError(f"Unserializable object {obj} of type {type(obj)}") TypeError: Unserializable object Empty DataFrame Columns: [] Index: [] of type <class 'pandas.core.frame.DataFrame'>` ### Checklist - [x] I have searched Superset docs and Slack and didn't find a solution to my problem. - [x] I have searched the GitHub issue tracker and didn't find a similar bug report. - [x] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
