[ https://issues.apache.org/jira/browse/HIVE-17238?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Janaki Lahorani reassigned HIVE-17238: -------------------------------------- Assignee: Janaki Lahorani > DPP isn't trigger for partitioned to partitioned join within a subquery > ----------------------------------------------------------------------- > > Key: HIVE-17238 > URL: https://issues.apache.org/jira/browse/HIVE-17238 > Project: Hive > Issue Type: Sub-task > Components: Spark > Reporter: Sahil Takiar > Assignee: Janaki Lahorani > > Queries such as: > {code} > 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); > {code} > Don't seem to trigger DPP from pt2 to pt3. -- This message was sent by Atlassian JIRA (v6.4.14#64029)