[
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)
