You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Zelaine Fong (JIRA)" <ji...@apache.org> on 2016/09/11 01:18:21 UTC

[jira] [Updated] (DRILL-2234) IOOB when streaming aggregate is on the left side of hash join

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

Zelaine Fong updated DRILL-2234:
--------------------------------
    Assignee: Boaz Ben-Zvi

> IOOB when streaming aggregate is on the left side of hash join
> --------------------------------------------------------------
>
>                 Key: DRILL-2234
>                 URL: https://issues.apache.org/jira/browse/DRILL-2234
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Relational Operators
>            Reporter: Mehant Baid
>            Assignee: Boaz Ben-Zvi
>             Fix For: Future
>
>
> This issue is similar to DRILL-2107. 
> Issue can be reproduced by enabling SwapJoinRule in DrillRuleSets and running the following query.
> alter session set `planner.slice_target` = 1;
> alter session set `planner.enable_hashagg` = false;
> alter session set `planner.enable_streamagg` = true;
> select l_suppkey, sum(l_extendedprice)/sum(l_quantity) as avg_price 
> from cp.`tpch/lineitem.parquet` where l_orderkey in
> (select o_orderkey from cp.`tpch/orders.parquet` where o_custkey = 2) 
> group by l_suppkey having sum(l_extendedprice)/sum(l_quantity) > 1850.0;



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)