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 5BCFC7826 for ; Fri, 9 Dec 2011 21:46:03 +0000 (UTC) Received: (qmail 2680 invoked by uid 500); 9 Dec 2011 21:46:03 -0000 Delivered-To: apmail-hive-dev-archive@hive.apache.org Received: (qmail 2650 invoked by uid 500); 9 Dec 2011 21:46:03 -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 2589 invoked by uid 500); 9 Dec 2011 21:46:02 -0000 Delivered-To: apmail-hadoop-hive-dev@hadoop.apache.org Received: (qmail 2563 invoked by uid 99); 9 Dec 2011 21:46:02 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 09 Dec 2011 21:46:02 +0000 X-ASF-Spam-Status: No, hits=-2001.2 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; Fri, 09 Dec 2011 21:46:00 +0000 Received: from hel.zones.apache.org (hel.zones.apache.org [140.211.11.116]) by hel.zones.apache.org (Postfix) with ESMTP id 6DF7710A872 for ; Fri, 9 Dec 2011 21:45:39 +0000 (UTC) Date: Fri, 9 Dec 2011 21:45:39 +0000 (UTC) From: "Namit Jain (Commented) (JIRA)" To: hive-dev@hadoop.apache.org Message-ID: <80458394.60369.1323467139451.JavaMail.tomcat@hel.zones.apache.org> In-Reply-To: <583064381.939.1297887685594.JavaMail.tomcat@hel.zones.apache.org> Subject: [jira] [Commented] (HIVE-1996) "LOAD DATA INPATH" fails when the table already contains a file of the same name MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/HIVE-1996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13166594#comment-13166594 ] Namit Jain commented on HIVE-1996: ---------------------------------- Yongqiang, can you take a look ? > "LOAD DATA INPATH" fails when the table already contains a file of the same name > -------------------------------------------------------------------------------- > > Key: HIVE-1996 > URL: https://issues.apache.org/jira/browse/HIVE-1996 > Project: Hive > Issue Type: Bug > Affects Versions: 0.7.0 > Reporter: Kirk True > Assignee: Chinna Rao Lalam > Attachments: HIVE-1996.1.Patch, HIVE-1996.2.Patch, HIVE-1996.Patch > > > Steps: > 1. From the command line copy the kv2.txt data file into the current user's HDFS directory: > {{$ hadoop fs -copyFromLocal /path/to/hive/sources/data/files/kv2.txt kv2.txt}} > 2. In Hive, create the table: > {{create table tst_src1 (key_ int, value_ string);}} > 3. Load the data into the table from HDFS: > {{load data inpath './kv2.txt' into table tst_src1;}} > 4. Repeat step 1 > 5. Repeat step 3 > Expected: > To have kv2.txt renamed in HDFS and then copied to the destination as per HIVE-307. > Actual: > File is renamed, but {{Hive.copyFiles}} doesn't "see" the change in {{srcs}} as it continues to use the same array elements (with the un-renamed, old file names). It crashes with this error: > {noformat} > java.lang.NullPointerException > at org.apache.hadoop.hive.ql.metadata.Hive.copyFiles(Hive.java:1725) > at org.apache.hadoop.hive.ql.metadata.Table.copyFiles(Table.java:541) > at org.apache.hadoop.hive.ql.metadata.Hive.loadTable(Hive.java:1173) > at org.apache.hadoop.hive.ql.exec.MoveTask.execute(MoveTask.java:197) > at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:130) > at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57) > at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1060) > at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:897) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:745) > at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:164) > at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:241) > at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:456) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at org.apache.hadoop.util.RunJar.main(RunJar.java:156) > {noformat} -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira