我遇到了一个奇怪的问题,通过SuperSet (apache孵化器)运行Hive查询:
SELECT
date,
sum(1) visits,
sum(price) revenue
FROM
visits
WHERE
date BETWEEN '2017-07-21' AND '2017-07-25'
AND country = 'US'
GROUP BY
date,
browser在运行超级集的终端(运行ubuntu的VM虚拟机虚拟机)中可以捕捉到所收到的错误:
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有趣的是,当日期是7/21-7/24时,它工作正常。我认为它必须执行w/内存操作,但是将浏览器添加到故事中(作为一个选项组)并没有改变这种行为(我的逻辑是,添加它会使查询甚至在7/21-7/24期间因为行数的增加而中断)。
不用说,当从工具启动时,查询运行得很好。
提前感谢!
发布于 2017-08-03 10:36:51
我的版本是0.18.x,这个问题在0.19中消失了。
https://stackoverflow.com/questions/45373996
复制相似问题