Has sombody facing some problem like that?
I've been facing some problems with OVERWRITE clause on command:
load data local inpath 'emp.dat' overwrite into table emp;
Loading data to table default.emp
Failed with exception Unable to move sourcehdfs://localhost:8020/tmp/hive-stabbler/hive_2014-10-09_12-13-44_624_7988255974532992081-1/-ext-10000 to destination /user/hive/warehouse/default.db/emp
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask
It seems could be a problem with overwrite parameter.
I've followed this cloudera instructions link
I saw the same problem here but it has no reply.
and this one from apache hive community related to the problem where the table has the same name of the table.
Yea I agree, it is mostly likely a permission error, I would check the hive logs to see exactly which file/dir path is giving the error.