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 >
