Sahil Takiar created HIVE-17238:
-----------------------------------
Summary: 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
Reporter: Sahil Takiar
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)
