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/01/15 23:14:26 UTC
[GitHub] sj-plenty opened a new issue #6697: Superset + Athena describe
table fails
sj-plenty opened a new issue #6697: Superset + Athena describe table fails
URL: https://github.com/apache/incubator-superset/issues/6697
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
SQLLab returns the result of the command `describe temperature;`
### Actual results
Errors with `3 columns passed, passed data had 1 columns`, and table schemas fail to load.
```
2019-01-15 22:07:56,693:INFO:root:Fetching cursor description
2019-01-15 22:07:56,693:ERROR:root:3 columns passed, passed data had 1 columns
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/superset/sql_lab.py", line 89, in get_sql_results
session=session, start_time=start_time)
File "/usr/local/lib/python3.6/site-packages/superset/sql_lab.py", line 216, in execute_sql
cdf = dataframe.SupersetDataFrame(data, cursor_description, db_engine_spec)
File "/usr/local/lib/python3.6/site-packages/superset/dataframe.py", line 74, in __init__
pd.DataFrame(list(data), columns=self.column_names).infer_objects())
File "/usr/local/lib/python3.6/site-packages/pandas/core/frame.py", line 387, in __init__
arrays, columns = _to_arrays(data, columns, dtype=dtype)
File "/usr/local/lib/python3.6/site-packages/pandas/core/frame.py", line 7461, in _to_arrays
dtype=dtype)
File "/usr/local/lib/python3.6/site-packages/pandas/core/frame.py", line 7540, in _list_to_arrays
coerce_float=coerce_float)
File "/usr/local/lib/python3.6/site-packages/pandas/core/frame.py", line 7598, in _convert_object_array
con=len(content)))
AssertionError: 3 columns passed, passed data had 1 columns
2019-01-15 22:07:56,694:DEBUG:root:[36m[stats_logger] (incr) error_sqllab_unhandled[0m
2019-01-15 22:07:56,706:ERROR:root:3 columns passed, passed data had 1 columns
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/superset/sql_lab.py", line 69, in session_scope
yield session
File "/usr/local/lib/python3.6/site-packages/superset/sql_lab.py", line 89, in get_sql_results
session=session, start_time=start_time)
File "/usr/local/lib/python3.6/site-packages/superset/sql_lab.py", line 216, in execute_sql
cdf = dataframe.SupersetDataFrame(data, cursor_description, db_engine_spec)
File "/usr/local/lib/python3.6/site-packages/superset/dataframe.py", line 74, in __init__
pd.DataFrame(list(data), columns=self.column_names).infer_objects())
File "/usr/local/lib/python3.6/site-packages/pandas/core/frame.py", line 387, in __init__
arrays, columns = _to_arrays(data, columns, dtype=dtype)
File "/usr/local/lib/python3.6/site-packages/pandas/core/frame.py", line 7461, in _to_arrays
dtype=dtype)
File "/usr/local/lib/python3.6/site-packages/pandas/core/frame.py", line 7540, in _list_to_arrays
coerce_float=coerce_float)
File "/usr/local/lib/python3.6/site-packages/pandas/core/frame.py", line 7598, in _convert_object_array
con=len(content)))
```
### Steps to reproduce
Set up awsathena+rest data source.
Go to sql lab
`describe table`
----------------------------------------------------------------
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:
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