You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Techy Teck <co...@gmail.com> on 2012/08/02 02:27:40 UTC
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask
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*
Re: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask
Posted by Bejoy Ks <be...@yahoo.com>.
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 <ga...@gmail.com>
To: "user@hive.apache.org" <us...@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 <co...@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
Re: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask
Posted by Gabriel Eisbruch <ga...@gmail.com>.
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 <co...@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*