[ 
https://issues.apache.org/jira/browse/HIVE-17248?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Sahil Takiar updated HIVE-17248:
--------------------------------
    Description: 
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}

Don't trigger DPP. {{srcpart}} is the partitioned by {{ds}} and {{hr}}. DPP 
could be triggered for the join {{(srcpart.ds = srcpart_date.ds)}}. 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.

  was:
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.


> 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}
> Don't trigger DPP. {{srcpart}} is the partitioned by {{ds}} and {{hr}}. DPP 
> could be triggered for the join {{(srcpart.ds = srcpart_date.ds)}}. 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)

Reply via email to