Support Questions
Find answers, ask questions, and share your expertise

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

New Contributor

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


Expert Contributor



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;



Chethan YM

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.