dmigo opened a new issue #4788: 'Must pass 2-d input' returned when trying to select an array URL: https://github.com/apache/incubator-superset/issues/4788 Make sure these boxes are checked before submitting your issue - thank you! - [*] I have checked the superset logs for python stacktraces and included it here as text if any - [*] I have reproduced the issue with at least the latest released version of superset - [*] I have checked the issue tracker for the same issue and I haven't found one similar ### Superset version 0.24.0 ### Expected results `[1]` is returned ### Actual results `Must pass 2-d input` ### Steps to reproduce The queries are running on Presto. Running ``` SQL SELECT ARRAY[1] ``` results in `Must pass 2-d input`. ![screen shot 2018-04-09 at 13 31 25](https://user-images.githubusercontent.com/7461607/38495623-8dd5b5a8-3bfa-11e8-8230-43dabb076436.png) While the following query executes and returns result as expected. ``` SQL SELECT 1,ARRAY[1] ``` ![screen shot 2018-04-09 at 13 31 13](https://user-images.githubusercontent.com/7461607/38495629-923b78b2-3bfa-11e8-8a0f-4fa4dab34b27.png) ### Stack trace Here is what I can find in console: ``` workers_1 | [2018-04-09 11:24:50,879: ERROR/ForkPoolWorker-15] Must pass 2-d input workers_1 | Traceback (most recent call last): workers_1 | File "/usr/local/lib/python3.6/dist-packages/superset/sql_lab.py", line 118, in get_sql_results workers_1 | template_params) workers_1 | File "/usr/local/lib/python3.6/dist-packages/superset/sql_lab.py", line 254, in execute_sql workers_1 | cdf = convert_results_to_df(cursor_description, data) workers_1 | File "/usr/local/lib/python3.6/dist-packages/superset/sql_lab.py", line 105, in convert_results_to_df workers_1 | pd.DataFrame(df_data, columns=column_names)) workers_1 | File "/usr/local/lib/python3.6/dist-packages/pandas/core/frame.py", line 361, in __init__ workers_1 | copy=copy) workers_1 | File "/usr/local/lib/python3.6/dist-packages/pandas/core/frame.py", line 513, in _init_ndarray workers_1 | values = _prep_ndarray(values, copy=copy) workers_1 | File "/usr/local/lib/python3.6/dist-packages/pandas/core/frame.py", line 6257, in _prep_ndarray workers_1 | raise ValueError('Must pass 2-d input') workers_1 | ValueError: Must pass 2-d input workers_1 | [2018-04-09 11:24:50,941: ERROR/ForkPoolWorker-15] Task superset.sql_lab.get_sql_results[f41361bc-5dd3-41de-b166-fa993da245bb] raised unexpected: ValueError('Must pass 2-d input',) workers_1 | Traceback (most recent call last): workers_1 | File "/usr/local/lib/python3.6/dist-packages/celery/app/trace.py", line 367, in trace_task workers_1 | R = retval = fun(*args, **kwargs) workers_1 | File "/usr/local/lib/python3.6/dist-packages/celery/app/trace.py", line 622, in __protected_call__ workers_1 | return self.run(*args, **kwargs) workers_1 | File "/usr/local/lib/python3.6/dist-packages/superset/sql_lab.py", line 118, in get_sql_results workers_1 | template_params) workers_1 | File "/usr/local/lib/python3.6/dist-packages/superset/sql_lab.py", line 254, in execute_sql workers_1 | cdf = convert_results_to_df(cursor_description, data) workers_1 | File "/usr/local/lib/python3.6/dist-packages/superset/sql_lab.py", line 105, in convert_results_to_df workers_1 | pd.DataFrame(df_data, columns=column_names)) workers_1 | File "/usr/local/lib/python3.6/dist-packages/pandas/core/frame.py", line 361, in __init__ workers_1 | copy=copy) workers_1 | File "/usr/local/lib/python3.6/dist-packages/pandas/core/frame.py", line 513, in _init_ndarray workers_1 | values = _prep_ndarray(values, copy=copy) workers_1 | File "/usr/local/lib/python3.6/dist-packages/pandas/core/frame.py", line 6257, in _prep_ndarray workers_1 | raise ValueError('Must pass 2-d input') workers_1 | ValueError: Must pass 2-d input ```
---------------------------------------------------------------- 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: us...@infra.apache.org With regards, Apache Git Services