[HIVE-17238] DPP isn't trigger for partitioned to partitioned join within a subquery

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Spark
• Target Version/s: 3.0.0
• Assignee: Janaki Lahorani
• Reporter: Sahil Takiar
• Created: 03/Aug/17 05:21
• Updated: 08/Jan/18 16:52

Description

Queries such as:

EXPLAIN SELECT count(*) FROM partitioned_table1 WHERE partitioned_table1.part_col IN (
SELECT partitioned_table2.col FROM partitioned_table2 JOIN partitioned_table3 ON
partitioned_table3.col = partitioned_table2.part_col AND partitioned_table2.col > 1);

Don't seem to trigger DPP from pt2 to pt3.