[HIVE-4689] For outerjoins, joinEmitInterval might make wrong result

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.11.0
• Fix Version/s: 0.12.0
• Component/s: Query Processor
• Assignee: Navis Ryu Assign to me
• Reporter: Navis Ryu
• Created: 09/Jun/13 03:57
• Updated: 01/Dec/16 11:52
• Resolved: 03/Jul/13 15:59

Description

Alias filter tag is calculated for each group and used for outer joins. But if joinEmitInterval is smaller than the group size, pre-matured alias filter tag would be used and might introduce different(wrong) result.

It can be observed in join_1to1.q test but I cannot imagine proper solution which does not override intention of joinEmitInterval. Should it be disabled for outer joins?

Issue Links

• is related to: HIVE-15327 Outerjoin might produce wrong result depending on joinEmitInterval value
• is related to: HIVE-4781 LEFT SEMI JOIN generates wrong results when the number of rows belonging to a single key of the right table exceed hive.join.emit.interval