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