Hi Techy To add on to Gabriel's response
Since one of the partitions got successfully added there is least chance of permissions issues on hive storage location unless you have made any permission changes recently. I assume you are trying to load data using the LOAD DATA statement, then you need to ensure that the user has sufficient permissions on the source directory in hdfs as well. Since it is a move operation happening under the hood the user need to have sufficient permissions on the source dir in hdfs as well as the table's storage location in hdfs. Regards, Bejoy KS ________________________________ From: Gabriel Eisbruch <gabrieleisbr...@gmail.com> To: "user@hive.apache.org" <user@hive.apache.org> Sent: Thursday, August 2, 2012 7:01 AM Subject: Re: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask Hi Techy this error use to appeare when the user executing the query has not permisions into the origin or target folder, if you create a single table (no externa) is probable that you has not permissions to write into /user/hive Respect to your before question, i am using snappy to compress the data stored and i have exelent results Slds! Gabriel. El 01/08/2012, a las 09:28 p.m., Techy Teck <comptechge...@gmail.com> escribió: I am trying to load data in to the date partition, so my data got succesfully loaded for 20120709 but when I tried to load the data for 20120710, then I am seeing the below exception. Can anyone suggest me why is it happening like this? > > >Loading data to table data_quality partition (ds=20120710) >Failed with exception replaceFiles: error while moving files from hdfs://ares-nn/tmp/hive-b_apdpds/hive_2012-08-02_06-52-06_655_1068176861485182317/10001 to /user/uname/data_quality/ds=20120710!!! >FAILED: Execution Error, return code 1 from >org.apache.hadoop.hive.ql.exec.MoveTask
