kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "lk_hadoop"<lk_had...@163.com>
Subject Re: Re: Re: jdbc query with limit not work
Date Tue, 28 May 2019 02:38:36 GMT
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"<lk_hadoop@163.com>
发送时间:2019-05-28 10:03
主题:Re: Re: jdbc query with limit not work
收件人:"user"<user@kylin.apache.org>
抄送:



2019-05-28 

lk_hadoop 



发件人:JiaTao Tao <taojiatao@gmail.com>
发送时间:2019-05-27 19:47
主题:Re: jdbc query with limit not work
收件人:"user"<user@kylin.apache.org>
抄送:

Hi
Try to set "kylin.query.max-return-rows" a larger value(>1042201), and re-run your query.



-- 



Regards!
Aron Tao


lk_hadoop <lk_hadoop@163.com> 于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 
Mime
View raw message