hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sahil Takiar (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-17238) DPP isn't trigger for partitioned to partitioned join within a subquery
Date Thu, 03 Aug 2017 05:22:00 GMT
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)

Mime
View raw message