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

Parth Chandra updated DRILL-2234:
---------------------------------
    Fix Version/s:     (was: 0.8.0)
                   0.9.0

> 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: Mehant Baid
>             Fix For: 0.9.0
>
>
> 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)

Reply via email to