Return-Path: 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 10414107CD for ; Wed, 18 Dec 2013 02:06:09 +0000 (UTC) Received: (qmail 30253 invoked by uid 500); 18 Dec 2013 02:06:08 -0000 Delivered-To: apmail-hive-dev-archive@hive.apache.org Received: (qmail 30167 invoked by uid 500); 18 Dec 2013 02:06:08 -0000 Mailing-List: contact dev-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list dev@hive.apache.org Received: (qmail 30081 invoked by uid 500); 18 Dec 2013 02:06:08 -0000 Delivered-To: apmail-hadoop-hive-dev@hadoop.apache.org Received: (qmail 30041 invoked by uid 99); 18 Dec 2013 02:06:08 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 18 Dec 2013 02:06:08 +0000 Date: Wed, 18 Dec 2013 02:06:08 +0000 (UTC) From: "Sergey Shelukhin (JIRA)" To: hive-dev@hadoop.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (HIVE-6052) metastore JDO filter pushdown for integers may produce unexpected results with non-normalized integer columns 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-6052?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13851272#comment-13851272 ] Sergey Shelukhin commented on HIVE-6052: ---------------------------------------- rb at https://reviews.apache.org/r/16339/ > metastore JDO filter pushdown for integers may produce unexpected results with non-normalized integer columns > ------------------------------------------------------------------------------------------------------------- > > Key: HIVE-6052 > URL: https://issues.apache.org/jira/browse/HIVE-6052 > Project: Hive > Issue Type: Bug > Affects Versions: 0.12.0, 0.13.0 > Reporter: Sergey Shelukhin > Assignee: Sergey Shelukhin > Attachments: HIVE-6052.patch > > > If integer partition columns have values stores in non-canonical form, for example with leading zeroes, the integer filter doesn't work. That is because JDO pushdown uses substrings to compare for equality, and SQL pushdown is intentionally crippled to do the same to produce same results. > Probably, since both SQL pushdown and integers pushdown are just perf optimizations, we can remove it for JDO (or make configurable and disable by default), and uncripple SQL. -- This message was sent by Atlassian JIRA (v6.1.4#6159)