psinger opened a new issue #4250: Tz-aware datetime.datetime cannot be converted to datetime64 unless utc=True URL: https://github.com/apache/incubator-superset/issues/4250 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 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 current master ### Expected results chart ### Actual results error: Tz-aware datetime.datetime cannot be converted to datetime64 unless utc=True ### Steps to reproduce Use date column in postgresql I am receiving the error ``Tz-aware datetime.datetime cannot be converted to datetime64 unless utc=True`` when I try to use a timestamp column that is a date column in postgresql. Timestamp columns work fine. Python/pandas trace: 2018-01-19 16:34:23,678:ERROR:root:Tz-aware datetime.datetime cannot be converted to datetime64 unless utc=True Traceback (most recent call last): File "/home/psinger/anaconda3/lib/python3.6/site-packages/pandas/core/tools/datetimes.py", line 444, in _convert_listlike values, tz = tslib.datetime_to_datetime64(arg) File "pandas/_libs/tslib.pyx", line 1796, in pandas._libs.tslib.datetime_to_datetime64 (pandas/_libs/tslib.c:33086) ValueError: Array must be all same time zone During handling of the above exception, another exception occurred: > Traceback (most recent call last): > File "/home/psinger/tmp/incubator-superset/superset/viz.py", line 273, in get_payload > df = self.get_df(query_obj) > File "/home/psinger/tmp/incubator-superset/superset/viz.py", line 124, in get_df > df[DTTM_ALIAS], utc=False, format=timestamp_format) > File "/home/psinger/anaconda3/lib/python3.6/site-packages/pandas/core/tools/datetimes.py", line 509, in to_datetime > values = _convert_listlike(arg._values, False, format) > File "/home/psinger/anaconda3/lib/python3.6/site-packages/pandas/core/tools/datetimes.py", line 447, in _convert_listlike > raise e > File "/home/psinger/anaconda3/lib/python3.6/site-packages/pandas/core/tools/datetimes.py", line 435, in _convert_listlike > require_iso8601=require_iso8601 > File "pandas/_libs/tslib.pyx", line 2355, in pandas._libs.tslib.array_to_datetime (pandas/_libs/tslib.c:46617) > File "pandas/_libs/tslib.pyx", line 2401, in pandas._libs.tslib.array_to_datetime (pandas/_libs/tslib.c:43251) > ValueError: Tz-aware datetime.datetime cannot be converted to datetime64 unless utc=True >
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
