What's the result when you were running in the Kylin Insight page? How did you set the limit parameter by using JDBC?
With Warm regards Billy Liu lk_hadoop <[email protected]> 于2019年5月28日周二 上午9:33写道： > > what I want is the limit clause should be pushed down to hbase. > > 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 > > >
