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

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: Future
• Component/s: Execution - Relational Operators
• Assignee: Boaz Ben-Zvi
• Reporter: Mehant Baid
• Created: 12/Feb/15 22:54
• Updated: 30/Mar/18 00:04

Description

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;

Issue Links

• is depended upon by: DRILL-2376 UNION ALL on Aggregates with GROUP BY returns incomplete results