[HIVE-20039] Bucket pruning: Left Outer Join on bucketed table gives wrong result

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.3.2, 3.0.0
• Fix Version/s: 3.2.0, 4.0.0-alpha-1
• Target Version/s: 3.2.0, 4.0.0
• Assignee: Deepak Jaiswal
• Reporter: Deepak Jaiswal
• Created: 30/Jun/18 17:13
• Updated: 17/Nov/22 08:54
• Resolved: 05/Jul/18 07:32

Description

Left outer join on bucketed table on certain cases gives wrong results.

Depending on the order in which the table-scans are walked through, the FilterPruner might end up using the wrong table scan's table properties on the other table.

Issue Links

• links to: RB