You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@drill.apache.org by "Boaz Ben-Zvi (JIRA)" <ji...@apache.org> on 2017/10/31 03:50:00 UTC

[jira] [Created] (DRILL-5915) Streaming aggregate with limit query does not return

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)