> Moving data to: >s3n://<access_key>:<secret_key>@my_bucket/a/b/2015-07-30/.hive-staging_hiv >e_2015-08-04_18-38-47_649_1476668515119011800-1/-ext-10000 > Failed with exception Wrong FS: >s3n://<access_key>:<secret_key>@my_bucket/a/b/2015-07-30/.hive-staging_hiv >e_2015-08-04_18-38-47_649_1476668515119011800-1/-ext-10002, expected: >hdfs://s .. > FAILED: Execution Error, return code 1 from >org.apache.hadoop.hive.ql.exec.MoveTask
Looks like the insert overwrite isnĀ¹t triggering the CopyTask - MoveTask is the wrong operation for cross-FS operations. You can try looking at the Explain plan and confirm that. Cheers, Gopal