fmos commented on issue #20155:
URL: https://github.com/apache/superset/issues/20155#issuecomment-1144873425
> I am facing same issue with all Time-series charts
Me too. For me, this issue was introduced with the upgrade to 1.5.0.
Unfortunately, a downgrade does not work ("Databases" is empty after downgrade).
Maybe the FutureWarning at the top of my (redacted) stack trace contains a
valuale hint for one of you:
> "Data is timezone-aware. Converting timezone-aware data to timezone-naive
by passing dtype='datetime64[ns]' to DataFrame or Series is deprecated and will
raise in a future version. Use `pd.Series(values).dt.tz_localize(None)`
instead."
```
Jun 02 15:09:25 demeter gunicorn[1697193]:
/srv/superset/local/lib/python3.8/site-packages/superset/common/query_context_processor.py:186:
FutureWarning: Data is timezone-aware. Converting timezone-aware data to
timezone-naive by passing dtype='datetime64[ns]' to DataFrame or Series is
deprecated and will raise in a future version. Use
`pd.Series(values).dt.tz_localize(None)` instead.
Jun 02 15:09:25 demeter gunicorn[1697193]: result =
query_context.datasource.query(query_object.to_dict())
Jun 02 15:09:25 demeter gunicorn[1697193]: Query SELECT DATE_TRUNC('year',
entry_date) AS __timestamp,
Jun 02 15:09:25 demeter gunicorn[1697193]: sum(our_fees) AS
"SUM(our_fees)"
Jun 02 15:09:25 demeter gunicorn[1697193]: FROM
Jun 02 15:09:25 demeter gunicorn[1697193]: (SELECT i.date AS invoice_date,
Jun 02 15:09:25 demeter gunicorn[1697193]: e.date AS entry_date,
...
Jun 02 15:09:25 demeter gunicorn[1697193]: WHERE entry_date >=
TO_TIMESTAMP('2012-01-01 00:00:00.000000', 'YYYY-MM-DD HH24:MI:SS.US')
Jun 02 15:09:25 demeter gunicorn[1697193]: AND entry_date <
TO_TIMESTAMP('2022-01-01 00:00:00.000000', 'YYYY-MM-DD HH24:MI:SS.US')
Jun 02 15:09:25 demeter gunicorn[1697193]: AND number = 970
Jun 02 15:09:25 demeter gunicorn[1697193]: AND subnumber = 1
Jun 02 15:09:25 demeter gunicorn[1697193]: GROUP BY DATE_TRUNC('year',
entry_date)
Jun 02 15:09:25 demeter gunicorn[1697193]: ORDER BY "SUM(our_fees)" DESC
Jun 02 15:09:25 demeter gunicorn[1697193]: LIMIT 10000 on schema public
failed
Jun 02 15:09:25 demeter gunicorn[1697193]: Traceback (most recent call last):
Jun 02 15:09:25 demeter gunicorn[1697193]: File
"/srv/superset/local/lib/python3.8/site-packages/superset/connectors/sqla/models.py",
line 1719, in query
Jun 02 15:09:25 demeter gunicorn[1697193]: df =
self.database.get_df(sql, self.schema, mutator=assign_column_label)
Jun 02 15:09:25 demeter gunicorn[1697193]: File
"/srv/superset/local/lib/python3.8/site-packages/superset/models/core.py", line
453, in get_df
Jun 02 15:09:25 demeter gunicorn[1697193]: df = result_set.to_pandas_df()
Jun 02 15:09:25 demeter gunicorn[1697193]: File
"/srv/superset/local/lib/python3.8/site-packages/superset/result_set.py", line
202, in to_pandas_df
Jun 02 15:09:25 demeter gunicorn[1697193]: return
self.convert_table_to_df(self.table)
Jun 02 15:09:25 demeter gunicorn[1697193]: File
"/srv/superset/local/lib/python3.8/site-packages/superset/result_set.py", line
177, in convert_table_to_df
Jun 02 15:09:25 demeter gunicorn[1697193]: return
table.to_pandas(integer_object_nulls=True)
Jun 02 15:09:25 demeter gunicorn[1697193]: File "pyarrow/array.pxi", line
757, in pyarrow.lib._PandasConvertible.to_pandas
Jun 02 15:09:25 demeter gunicorn[1697193]: File "pyarrow/table.pxi", line
1748, in pyarrow.lib.Table._to_pandas
Jun 02 15:09:25 demeter gunicorn[1697193]: File
"/srv/superset/local/lib/python3.8/site-packages/pyarrow/pandas_compat.py",
line 789, in table_to_blockmanager
Jun 02 15:09:25 demeter gunicorn[1697193]: blocks =
_table_to_blocks(options, table, categories, ext_columns_dtypes)
Jun 02 15:09:25 demeter gunicorn[1697193]: File
"/srv/superset/local/lib/python3.8/site-packages/pyarrow/pandas_compat.py",
line 1130, in _table_to_blocks
Jun 02 15:09:25 demeter gunicorn[1697193]: return
[_reconstruct_block(item, columns, extension_columns)
Jun 02 15:09:25 demeter gunicorn[1697193]: File
"/srv/superset/local/lib/python3.8/site-packages/pyarrow/pandas_compat.py",
line 1130, in <listcomp>
Jun 02 15:09:25 demeter gunicorn[1697193]: return
[_reconstruct_block(item, columns, extension_columns)
Jun 02 15:09:25 demeter gunicorn[1697193]: File
"/srv/superset/local/lib/python3.8/site-packages/pyarrow/pandas_compat.py",
line 733, in _reconstruct_block
Jun 02 15:09:25 demeter gunicorn[1697193]: dtype =
make_datetimetz(item['timezone'])
Jun 02 15:09:25 demeter gunicorn[1697193]: File
"/srv/superset/local/lib/python3.8/site-packages/pyarrow/pandas_compat.py",
line 758, in make_datetimetz
Jun 02 15:09:25 demeter gunicorn[1697193]: tz =
pa.lib.string_to_tzinfo(tz)
Jun 02 15:09:25 demeter gunicorn[1697193]: File "pyarrow/types.pxi", line
1927, in pyarrow.lib.string_to_tzinfo
Jun
02 15:09:25 demeter gunicorn[1697193]: File "pyarrow/error.pxi", line 143, in
pyarrow.lib.pyarrow_internal_check_status
Jun 02 15:09:25 demeter gunicorn[1697193]: File
"/usr/lib/python3/dist-packages/pytz/__init__.py", line 181, in timezone
Jun 02 15:09:25 demeter gunicorn[1697193]: raise
UnknownTimeZoneError(zone)
Jun 02 15:09:25 demeter gunicorn[1697193]:
pytz.exceptions.UnknownTimeZoneError: '+01'
Jun 02 15:09:25 demeter gunicorn[1697193]: 192.168.0.121 - -
[02/Jun/2022:15:09:25 +0200] "POST
/api/v1/chart/data?form_data=%7B%22slice_id%22%3A211%7D&dashboard_id=13&force
HTTP/1.0" 400 27 "https://[...]"; "Mozilla/5.0 (Windows NT 10.0; Win64; x64;
rv:91.0) Gecko/20100101 Firefox/91.0"
Jun 02 15:09:25 demeter gunicorn[1697193]: [2022-06-02 15:09:25 +0200]
[1697193] [DEBUG] Closing connection.
```
--
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]
