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)
