drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Boaz Ben-Zvi (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-5915) Streaming aggregate with limit query does not return
Date Tue, 31 Oct 2017 03:54:00 GMT

     [ https://issues.apache.org/jira/browse/DRILL-5915?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Boaz Ben-Zvi updated DRILL-5915:
--------------------------------
    Attachment: 26080f78-3fe8-7f2e-9815-9a2ae1a4bc90.sys.drill

> 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 -- 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)

Mime
View raw message