[DRILL-1162] 25 way join ended up with OOM

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Fix Version/s: Future
• Component/s: Execution - Flow, Query Planning & Optimization
• Assignee: Unassigned
• Reporter: Rahul Kumar Challapalli
• Created: 21/Jul/14 21:47
• Updated: 13/Jun/22 18:23

Description

git.commit.id.abbrev=e5c2da0

The below query results in 0 results being returned

select count(*) from `lineitem1.parquet` a 
inner join `part.parquet` j on a.l_partkey = j.p_partkey 
inner join `orders.parquet` k on a.l_orderkey = k.o_orderkey 
inner join `supplier.parquet` l on a.l_suppkey = l.s_suppkey 
inner join `partsupp.parquet` m on j.p_partkey = m.ps_partkey and l.s_suppkey = m.ps_suppkey 
inner join `customer.parquet` n on k.o_custkey = n.c_custkey 
inner join `lineitem2.parquet` b on a.l_orderkey = b.l_orderkey 
inner join `lineitem2.parquet` c on a.l_partkey = c.l_partkey 
inner join `lineitem2.parquet` d on a.l_suppkey = d.l_suppkey 
inner join `lineitem2.parquet` e on a.l_extendedprice = e.l_extendedprice 
inner join `lineitem2.parquet` f on a.l_comment = f.l_comment 
inner join `lineitem2.parquet` g on a.l_shipdate = g.l_shipdate 
inner join `lineitem2.parquet` h on a.l_commitdate = h.l_commitdate 
inner join `lineitem2.parquet` i on a.l_receiptdate = i.l_receiptdate 
inner join `lineitem2.parquet` o on a.l_receiptdate = o.l_receiptdate 
inner join `lineitem2.parquet` p on a.l_receiptdate = p.l_receiptdate 
inner join `lineitem2.parquet` q on a.l_receiptdate = q.l_receiptdate 
inner join `lineitem2.parquet` r on a.l_receiptdate = r.l_receiptdate 
inner join `lineitem2.parquet` s on a.l_receiptdate = s.l_receiptdate 
inner join `lineitem2.parquet` t on a.l_receiptdate = t.l_receiptdate 
inner join `lineitem2.parquet` u on a.l_receiptdate = u.l_receiptdate 
inner join `lineitem2.parquet` v on a.l_receiptdate = v.l_receiptdate 
inner join `lineitem2.parquet` w on a.l_receiptdate = w.l_receiptdate 
inner join `lineitem2.parquet` x on a.l_receiptdate = x.l_receiptdate;

However when we remove the last 'inner join' and run the query it returns '716372534'. Since the last inner join is similar to the one's before it, it should match some records and return the data appropriately.

The logs indicated that it actually returned 0 results. Attached the log file.

Issue Links

• links to: GitHub Pull Request #905