Return-Path: 
 <dev-return-44773-apmail-hive-dev-archive=hive.apache.org@hive.apache.org>
X-Original-To: apmail-hive-dev-archive@www.apache.org
Delivered-To: apmail-hive-dev-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id A1964EDBE
	for <apmail-hive-dev-archive@www.apache.org>;
 Wed, 16 Jan 2013 04:54:16 +0000 (UTC)
Received: (qmail 66966 invoked by uid 500); 16 Jan 2013 04:54:16 -0000
Delivered-To: apmail-hive-dev-archive@hive.apache.org
Received: (qmail 66485 invoked by uid 500); 16 Jan 2013 04:54:15 -0000
Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@hive.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@hive.apache.org>
List-Post: <mailto:dev@hive.apache.org>
List-Id: <dev.hive.apache.org>
Reply-To: dev@hive.apache.org
Delivered-To: mailing list dev@hive.apache.org
Received: (qmail 65832 invoked by uid 500); 16 Jan 2013 04:54:13 -0000
Delivered-To: apmail-hadoop-hive-dev@hadoop.apache.org
Received: (qmail 65808 invoked by uid 99); 16 Jan 2013 04:54:13 -0000
Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 16 Jan 2013 04:54:13 +0000
Date: Wed, 16 Jan 2013 04:54:12 +0000 (UTC)
From: "Namit Jain (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: <JIRA.12627584.1358220647873.143266.1358312052947@arcas>
In-Reply-To: <JIRA.12627584.1358220647873@arcas>
References: <JIRA.12627584.1358220647873@arcas>
Subject: [jira] [Commented] (HIVE-3899) Partition pruning fails on
 <constant> = <constant> expression
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394


    [ https://issues.apache.org/jira/browse/HIVE-3899?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13554743#comment-13554743 ] 

Namit Jain commented on HIVE-3899:
----------------------------------

+1
                
> Partition pruning fails on <constant> = <constant> expression
> -------------------------------------------------------------
>
>                 Key: HIVE-3899
>                 URL: https://issues.apache.org/jira/browse/HIVE-3899
>             Project: Hive
>          Issue Type: Bug
>          Components: Metastore, Query Processor
>    Affects Versions: 0.11.0
>            Reporter: Kevin Wilfong
>            Assignee: Kevin Wilfong
>         Attachments: HIVE-3899.1.patch.txt
>
>
> When a query has a filter that is the conjunction of only
> <partition_column> = <string constant>
> and
> <string constant> = <string constant>
> The whole filter will be passed to the metastore's get_partitions_by_filter method.  The grammar used to parse the filter only supports filters where one side is a column, so it fails on the <constant> = <constant> expression.
> These should be caught in the checkJDOPushDown method in the Utilities class.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira