Boaz Ben-Zvi created DRILL-5915: ----------------------------------- Summary: Streaming aggregate with limit query does not return Key: DRILL-5915 URL: https://issues.apache.org/jira/browse/DRILL-5915 Project: Apache Drill Issue Type: Bug Components: Execution - Relational Operators Affects Versions: 1.11.0 Reporter: Boaz Ben-Zvi
Reading a 1M rows table, in embedded mode, using sort+streaming_aggr -- the work is complete, but the query does not return (see attached profile) {code} alter session set `planner.enable_hashagg` = false; select b.g, b.s from (select gby_int32, gby_date g, gby_int32_rand, sum(int32_field) s from dfs.`/data/PARQUET-1M.parquet` group by gby_int32, gby_date, gby_int32_rand) b limit 30; {code} -- This message was sent by Atlassian JIRA (v6.4.14#64029)