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: jdbc query with limit not work
Date Tue, 28 May 2019 01:22:46 GMT
what I want is the limit clause should be pushed down to hbase.

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