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 F1BF867A5 for ; Tue, 19 Jul 2011 16:51:23 +0000 (UTC) Received: (qmail 63773 invoked by uid 500); 19 Jul 2011 16:51:23 -0000 Delivered-To: apmail-hive-dev-archive@hive.apache.org Received: (qmail 63725 invoked by uid 500); 19 Jul 2011 16:51:23 -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 63707 invoked by uid 500); 19 Jul 2011 16:51:22 -0000 Delivered-To: apmail-hadoop-hive-dev@hadoop.apache.org Received: (qmail 63701 invoked by uid 99); 19 Jul 2011 16:51:22 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 19 Jul 2011 16:51:22 +0000 X-ASF-Spam-Status: No, hits=-2001.1 required=5.0 tests=ALL_TRUSTED,RP_MATCHES_RCVD X-Spam-Check-By: apache.org Received: from [140.211.11.116] (HELO hel.zones.apache.org) (140.211.11.116) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 19 Jul 2011 16:51:21 +0000 Received: from hel.zones.apache.org (hel.zones.apache.org [140.211.11.116]) by hel.zones.apache.org (Postfix) with ESMTP id 4167E44CCC for ; Tue, 19 Jul 2011 16:51:01 +0000 (UTC) Date: Tue, 19 Jul 2011 16:51:01 +0000 (UTC) From: "jiraposter@reviews.apache.org (JIRA)" To: hive-dev@hadoop.apache.org Message-ID: <276343162.4561.1311094261264.JavaMail.tomcat@hel.zones.apache.org> In-Reply-To: <1033901353.25171.1301594765842.JavaMail.tomcat@hel.zones.apache.org> Subject: [jira] [Commented] (HIVE-2086) Data loss with external table 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-2086?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13067833#comment-13067833 ] jiraposter@reviews.apache.org commented on HIVE-2086: ----------------------------------------------------- ----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/604/ ----------------------------------------------------------- (Updated 2011-07-19 16:50:07.742470) Review request for hive. Changes ------- The bug was fixed as a part of HIVE-1218, and this diff adds some regression tests for this particular issue. Summary ------- Review request for HIVE-2086. The external parameters were being set, but then being zeroed out by a call to params.clear(), resulting in an external table that wasn't marked as external. This addresses bug HIVE-2086. https://issues.apache.org/jira/browse/HIVE-2086 Diffs (updated) ----- build-common.xml b6807fa data/files/ext_test/test.dat PRE-CREATION ql/src/test/org/apache/hadoop/hive/ql/QTestUtil.java 6d742e5 ql/src/test/queries/clientpositive/create_like.q 3f8e58d ql/src/test/results/clientpositive/create_like.q.out 118235e Diff: https://reviews.apache.org/r/604/diff Testing ------- Automated tests added Thanks, Jonathan > Data loss with external table > ----------------------------- > > Key: HIVE-2086 > URL: https://issues.apache.org/jira/browse/HIVE-2086 > Project: Hive > Issue Type: Bug > Components: Metastore > Affects Versions: 0.7.0 > Environment: Amazon elastics mapreduce cluster > Reporter: Q Long > Assignee: Jonathan Natkins > Attachments: HIVE-2086.1.patch, HIVE-2086.2.patch, create_like.q.out > > > Data loss when using "create external table like" statement. > 1) Set up an external table S, point to location L. Populate data in S. > 2) Create another external table T, using statement like this: > create external table T like S location L > Make sure table T point to the same location as the original table S. > 3) Query table T, see the same set of data in S. > 4) drop table T. > 5) Query table S will return nothing, and location L is deleted. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira