python - SuperSet Hive Query issue - expected data in columnar format -
i'm having weird issue w/ running following hive query via superset (apache incubator):
select date, sum(1) visits, sum(price) revenue visits date between '2017-07-21' , '2017-07-25' , country = 'us' group date, browser
error i'm getting can caught in terminal ran superset (vm virtual box virtual machine running ubuntu):
traceback (most recent call last): file "/home/userxx/venv/local/lib/python2.7/site-packages/superset/sql_lab.py", line 182, in execute_sql db_engine_spec.handle_cursor(cursor, query, session) file "/home/userxx/venv/local/lib/python2.7/site-packages/superset/db_engine_specs.py", line 726, in handle_cursor resp = cursor.fetch_logs() file "/home/userxx/venv/local/lib/python2.7/site-packages/superset/db_engines/hive.py", line 34, in fetch_logs response.results.rows, 'expected data in columnar format' assertionerror
the fun part it's working ok when date period 7/21 - 7/24. figured has w/ memory, adding browsers story (as group option) didn't change behavior (my logic adding break query period 7/21 - 7/24 due increased number of rows).
needless say, query runs when started e.g. sql developer tool.
thanks in advance!
my version 0.18.x , issue disappeared in 0.19
Comments
Post a Comment