You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Mehant Baid (JIRA)" <ji...@apache.org> on 2015/02/12 23:55:12 UTC

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

Mehant Baid created DRILL-2234:
----------------------------------

             Summary: 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.8.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)