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:[stats_logger] (incr) error_sqllab_unhandled
   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