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 9AE4D1171C for ; Thu, 24 Apr 2014 06:39:24 +0000 (UTC) Received: (qmail 44728 invoked by uid 500); 24 Apr 2014 06:39:21 -0000 Delivered-To: apmail-hive-dev-archive@hive.apache.org Received: (qmail 44651 invoked by uid 500); 24 Apr 2014 06:39:20 -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 44629 invoked by uid 500); 24 Apr 2014 06:39:19 -0000 Delivered-To: apmail-hadoop-hive-dev@hadoop.apache.org Received: (qmail 44610 invoked by uid 99); 24 Apr 2014 06:39:18 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 24 Apr 2014 06:39:18 +0000 Date: Thu, 24 Apr 2014 06:39:18 +0000 (UTC) From: "Ashutosh Chauhan (JIRA)" To: hive-dev@hadoop.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (HIVE-6945) issues with dropping partitions on Oracle 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-6945?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13979355#comment-13979355 ] Ashutosh Chauhan commented on HIVE-6945: ---------------------------------------- +1 > issues with dropping partitions on Oracle > ----------------------------------------- > > Key: HIVE-6945 > URL: https://issues.apache.org/jira/browse/HIVE-6945 > Project: Hive > Issue Type: Bug > Affects Versions: 0.13.0 > Reporter: Sergey Shelukhin > Assignee: Sergey Shelukhin > Attachments: HIVE-6945.01.patch, HIVE-6945.02.patch, HIVE-6945.patch > > > 1) Direct SQL is broken on Oracle due to the usage of NUMBER type which is translated by DN into decimal rather than long. This appears to be specific to some cases because it seemed to have worked before (different version of Oracle? JDBC? DN? Maybe depends on whether db was auto-created). > 2) When partition dropping code falls back to JDO, it creates objects to return, then drops partitions. It appears that dropping makes DN objects invalid. We create metastore partition objects out of DN objects before drop, however the list of partition column values is re-used, rather than copied, into these. DN appears to clear this list during drop, so the returned object becomes invalid and the exception is thrown. -- This message was sent by Atlassian JIRA (v6.2#6252)