AnsweredAssumed Answered

Hive failed with MoveTask

Question asked by feeblefakie on Jul 28, 2012
Latest reply on Jan 8, 2015 by nshindurkar
Hi,

Hive alaways fails with MoveTask like below.

<pre>
Failed with exception Unable to move results from maprfs://192.168.121.1:7222/tmp/hive-hiroyuki/hive_2012-07-29_03-14-49_955_5299334395045350201/-ext-10000 to destination directory: /user/hive/warehouse/my.db/mytable
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask
</pre>

hive.log says as following, but not informative.

<pre>
2012-07-29 03:34:14,205 ERROR exec.MoveTask (SessionState.java:printError(343)) - Failed with exception Unable to move results from maprfs://192.168.121.1:7222/tmp/hive-hiroyuki/hive_2012-07-29_03-14-49_955_5299334395045350201/-ext-10000 to destination directory: /user/hive/warehouse/sf1400.db/q17_small_quantity_order_revenueorg.apache.hadoop.hive.ql.metadata.HiveException: Unable to move results from maprfs://192.168.121.1:7222/tmp/hive-hiroyuki/hive_2012-07-29_03-14-49_955_5299334395045350201/-ext-10000 to destination directory: /user/hive/warehouse/sf1400.db/q17_small_quantity_order_revenue    at org.apache.hadoop.hive.ql.metadata.Hive.replaceFiles(Hive.java:1813)
    at org.apache.hadoop.hive.ql.metadata.Table.replaceFiles(Table.java:528)    at org.apache.hadoop.hive.ql.metadata.Hive.loadTable(Hive.java:1187)
    at org.apache.hadoop.hive.ql.exec.MoveTask.execute(MoveTask.java:197)
    at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:130)
    at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
    at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1063)
    at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:900)
    at org.apache.hadoop.hive.ql.Driver.run(Driver.java:748)
    at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:164)
    at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:241)
    at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:425)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.apache.hadoop.util.RunJar.main(RunJar.java:186)

2012-07-29 03:34:14,209 ERROR ql.Driver (SessionState.java:printError(343)) - FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask
</pre>

Usually this kind of error message is related to the permissions of HDFS directories,
but I think there is no problem about permissions.

Does anyone know what's going on ?
(Is there any log ?)

Thanks in advance.

Outcomes