Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Fri, 4 Aug 2017 01:03:00 +0000 (UTC)
From: "Sahil Takiar (JIRA)" <jira@apache.org>
To: dev@hive.apache.org
Message-ID: <JIRA.13092346.1501808552000.90099.1501808580085@Atlassian.JIRA>
In-Reply-To: <JIRA.13092346.1501808552000@Atlassian.JIRA>
References: <JIRA.13092346.1501808552000@Atlassian.JIRA> <JIRA.13092346.1501808552608@jira-lw-us.apache.org>
Subject: [jira] [Created] (HIVE-17248) DPP isn't triggered if static pruning
 is done for one of the partition columns
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Fri, 04 Aug 2017 01:03:04 -0000

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)