[jira] [Created] (HIVE-17248) DPP isn't triggered if static pruning is done for one of the partition columns

["Sahil Takiar (JIRA)" <ji...@apache.org>]

Sahil Takiar created HIVE-17248:
-----------------------------------

             Summary: DPP isn't triggered if static pruning is done for one of the partition columns
                 Key: HIVE-17248
                 URL: https://issues.apache.org/jira/browse/HIVE-17248
             Project: Hive
          Issue Type: Bug
            Reporter: Sahil Takiar


Queries such as:

{code}
EXPLAIN select count(*) from srcpart join srcpart_date on (srcpart.ds = srcpart_date.ds) join srcpart_hour on (srcpart.hr = srcpart_hour.hr) 
where srcpart_date.`date` = '2008-04-08' and srcpart.hr = 13
{code}

Where {{srcpart}} is the partitioned by {{ds}} and {{hr}}. DPP isn't triggered from for the join {{(srcpart.ds = srcpart_date.ds)}}, even though it could be. I'm guessing its because static pruning is triggered for the {{(srcpart.hr = srcpart_hour.hr)}} join condition.

Affects Hive-on-Tez and Hive-on-Spark.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)