I've know the reason , because GTCubeStorageQueryBase.enableStorageLimitIfPossible method will change the limit push down behavior.
2019-05-28 lk_hadoop 发件人："lk_hadoop"<[email protected]> 发送时间：2019-05-28 10:38 主题：Re: Re: Re: jdbc query with limit not work 收件人："user"<[email protected]>,"lk_hadoop"<[email protected]> 抄送： I was useing JDBC , I just add the limit clause at the end of the query sql . And When I do a query with aggregate functions , I can see the log like : storage.StorageContext:167 : Enabling limit push down: 200000 at level: LIMIT_ON_RETURN_SIZE when I qury what values dose a dim have , for example : "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" I can't see any limit push down log . But, What I really want is limit push down level : LIMIT_ON_SCAN I have config the property : kylin.storage.limit-push-down-enabled=true 2019-05-28 lk_hadoop 发件人："lk_hadoop"<[email protected]> 发送时间：2019-05-28 10:03 主题：Re: Re: jdbc query with limit not work 收件人："user"<[email protected]> 抄送： 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
