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

Reply via email to