I tried this command. it gives error. The directory UAE is created but file is not copied. Please help and tell a way to delete UAE directory.

LOAD DATA INPATH '/user/cloudera/class6/input/page_view_20140415_UAE.csv' INTO TABLE page_view PARTITION(dt='2014-04-15', country='UAE');
Loading data to table dz01.page_view partition (dt=2014-04-15, country=UAE)
Failed with exception Unable to move sourcehdfs://localhost.localdomain:8020/user/cloudera/class6/input/page_view_20140415_UAE.csv to destination hdfs://localhost.localdomain:8020/user/hive/warehouse/dz01.db/page_view/dt=2014-04-15/country=UAE/page_view_20140415_UAE.csv
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask


2 Answer(s)


Hi I got the solution i was running hive by sudo hive because of which the problem came. It is resolved now. Thanks anyways.


Hi Abhishek,

Thanks for the confirmation.