2019-05-28
lk_hadoop 发件人：JiaTao Tao <[email protected]> 发送时间：2019-05-27 19:47 主题：Re: jdbc query with limit not work 收件人："user"<[email protected]> 抄送： Hi Try to set "kylin.query.max-return-rows" a larger value(>1042201), and re-run your query. -- Regards! Aron Tao lk_hadoop <[email protected]> 于2019年5月27日周一 上午11:00写道： hi,all: I'm using kylin2.6.1 , when I use JDBC Driver to connect to Kylin and query data, I got such error : org.apache.kylin.rest.exception.InternalErrorException: Query returned 1042201 rows exceeds threshold 1000000 while executing SQL: "SELECT "SH_FETCH_SALE_BASE_FACT_ALL_NEW"."GOODS_SPEC" FROM "GJST"."SH_FETCH_SALE_BASE_FACT_ALL_NEW" "SH_FETCH_SALE_BASE_FACT_ALL_NEW" GROUP BY "SH_FETCH_SALE_BASE_FACT_ALL_NEW"."GOODS_SPEC" ORDER BY "SH_FETCH_SALE_BASE_FACT_ALL_NEW"."GOODS_SPEC" limit 1000" why ？ 2019-05-27 lk_hadoop
