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