Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask

[#1]

Hi Team,

I am running a simple create table statement 

create table mktplc_smith.gpottabwsr_wiser_vcs_pid_gmv_visits2 as

select * from dwhd_smith.smith_content_offer_storespecific_attr;

Moving data to: hdfs://dwhadoopl-prod/user/hive/warehouse/mktplc_smith.db/gpottabwsr_wiser_vcs_pid_gmv_visits2
Failed with exception Unable to move source hdfs://dwhadoopl-prod/user/hive/warehouse/mktplc_smith.db/.hive-staging_hive_2022-05-06_10-47-52_762_6293570038676837754-1/-ext-10001 to destination hdfs://dwhadoopl-prod/user/hive/warehouse/mktplc_smith.db/gpottabwsr_wiser_vcs_pid_gmv_visits2
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask

Please help how to resolve this error

[#2]

Hi,

The above log snippet does not give enough details you need to check complete HS2 log file for any other related errors. This error occurs for multiple reasons.

1. Does it work for any other user? can you change the user and try?

2. Check if you have any permission issue for this path/user.

3. Is encryption zone enabled? can set the below property in the beeline and retry the query?

     set hive.exec.scratchdir=.staging;

Regards,

Chethan YM