[
https://issues.apache.org/jira/browse/DRILL-5915?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Boaz Ben-Zvi updated DRILL-5915:
--------------------------------
Description:
Reading a 1M rows table, in embedded mode, using sort+streaming_aggr , followed
by a LIMIT -- 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}
Without the LIMIT clause the query runs, completes and returns OK.
was:
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}
> 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
> Attachments: 26080f78-3fe8-7f2e-9815-9a2ae1a4bc90.sys.drill
>
>
> Reading a 1M rows table, in embedded mode, using sort+streaming_aggr ,
> followed by a LIMIT -- 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}
> Without the LIMIT clause the query runs, completes and returns OK.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
