Hello,
Loading data from one swift container into external table pointing to another container is failing for me. hive> load data inpath 'swift://mycontainer.default/source_test' into table my_test; Loading data to table default.my_test Failed with exception copyFiles: error while moving files!!! Cannot move swift://mycontainer.default/source_test/AK.TXT to swift://test .default/my_test/AK.TXT FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask hive> Here is complete stacktrace 2018-02-02 21:27:28,309 ERROR [main]: exec.Task (SessionState.java:printError(962)) - Failed with exception copyFiles: error while moving files!!! Cannot move swift://mycontainer.default/source_test/AK.TXT to swift://test.default/my_test/AK.TXT org.apache.hadoop.hive.ql.metadata.HiveException: copyFiles: error while moving files!!! Cannot move swift://mycontainer.default/source_test/AK.TXT to swift://test.default/my_test/AK.TXT at org.apache.hadoop.hive.ql.metadata.Hive.copyFiles(Hive.java:2784) at org.apache.hadoop.hive.ql.metadata.Hive.loadTable(Hive.java:1664) at org.apache.hadoop.hive.ql.exec.MoveTask.execute(MoveTask.java:298) at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:160) at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:89) at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1728) at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1485) at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1262) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1126) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1116) at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:216) at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:168) at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:379) at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:739) at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:684) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:624) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.hadoop.util.RunJar.run(RunJar.java:221) at org.apache.hadoop.util.RunJar.main(RunJar.java:136) Caused by: java.io.IOException:Cannot move swift://mycontainer.default/source_test/AK.TXT to swift://test.default/my_test/AK.TXT at org.apache.hadoop.hive.ql.metadata.Hive.copyFiles(Hive.java:2777) ... 21 more hive version = 1.2.1 Any help is appreciated. Thanks