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 

Reply via email to