[HIVE-3315] Propagates filters which are on the join condition transitively

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 0.10.0
• Fix Version/s: 0.10.0
• Component/s: Query Processor
• Hadoop Flags: Reviewed
• Assignee: Navis Ryu
• Reporter: Navis Ryu
• Created: 28/Jul/12 07:26
• Updated: 10/Jan/13 19:53
• Resolved: 27/Sep/12 17:20

Description

explain select src1.key from src src1 join src src2 on src1.key=src2.key and src1.key < 100;

In this case, filter on join condition src1.key < 100 can be propagated transitively to src2 by src2.key < 100.