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

["Sean Hsuan-Yi Chu (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-2234?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14523413#comment-14523413 ] 

Sean Hsuan-Yi Chu commented on DRILL-2234:
------------------------------------------

It is IOOB in streamAgg. Reassign to [~mehant]

> 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: Sean Hsuan-Yi Chu
>             Fix For: 1.0.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)