[HIVE-8888] Mapjoin with LateralViewJoin generates wrong plan in Tez

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.15.0
• Fix Version/s: 1.0.0
• Assignee: Prasanth Jayachandran Assign to me
• Reporter: Prasanth Jayachandran
• Created: 15/Nov/14 04:52
• Updated: 23/May/22 09:54
• Resolved: 02/Dec/14 21:36

Description

Queries like these

with sub1 as
(select aid, avalue from expod1 lateral view explode(av) avs as avalue ),
sub2 as
(select bid, bvalue from expod2 lateral view explode(bv) bvs as bvalue)
select sub1.aid, sub1.avalue, sub2.bvalue
from sub1,sub2
where sub1.aid=sub2.bid;

generates twice the number of rows in Tez when compared to MR.

Issue Links

• relates to: HIVE-10379 Wrong result when executing with tez
• links to: Review Board