You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2019/04/10 04:03:53 UTC
[GitHub] [incubator-superset] iannamkr opened a new issue #7270: date_trunc
function when connect to hive
iannamkr opened a new issue #7270: date_trunc function when connect to hive
URL: https://github.com/apache/incubator-superset/issues/7270
Make sure these boxes are checked before submitting your issue - thank you!
- [x] I have checked the superset logs for python stacktraces and included it here as text if there are any.
- [x] I have reproduced the issue with at least the latest released version of superset.
- [x] I have checked the issue tracker for the same issue and I haven't found one similar.
### Superset version
0.28.1
### Expected results
### Actual results
```
errorCode=10011, errorMessage="Error while compiling statement: FAILED: SemanticException [Error 10011]: Line 6:9 Invalid function 'date_trunc'"), operationHandle=None)
Traceback (most recent call last):
File "/usr/lib/python3.6/site-packages/superset/connectors/sqla/models.py", line 783, in query
df = self.database.get_df(sql, self.schema)
File "/usr/lib/python3.6/site-packages/superset/models/core.py", line 789, in get_df
self.db_engine_spec.execute(cursor, sqls[-1])
File "/usr/lib/python3.6/site-packages/superset/db_engine_specs.py", line 1268, in execute
cursor.execute(query, **kwargs)
File "/usr/lib/python3.6/site-packages/pyhive/hive.py", line 365, in execute
_check_status(response)
File "/usr/lib/python3.6/site-packages/pyhive/hive.py", line 495, in _check_status
raise OperationalError(response)
```
### Steps to reproduce
When I create time series bar chart, Superset uses 'date_trunc' function in hiveql group by clause and it raise exception.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org