"insert overwrite directory" for Multilevel directory fails.
------------------------------------------------------------
Key: HIVE-2265
URL: https://issues.apache.org/jira/browse/HIVE-2265
Project: Hive
Issue Type: Bug
Components: Query Processor
Affects Versions: 0.7.1, 0.7.0
Environment: SuSE-Linux-11
Reporter: rohithsharma
Couldnot able to complete query execution for "insert overwrite directory"
query when the Directory path is Multilevel.
create table test ( a int , b int);
load data local inpath '/home/test.txt' into table test;
insert overwrite directory '/test' select * f rom test;(This querjy execute
successfully)
insert overwrite directory '/test/test/test' select * f rom test;(This query is
throwing below exception)
{noformat}
2011-06-27 12:00:15,383 ERROR exec.MoveTask (SessionState.java:printError(343))
- Failed with exception Unable to rename:
hdfs://10.18.40.99:9000/tmp/hive-root/hive_2011-06-27_11-59-52_522_5805414771967651042/-ext-10000
to: /test/test/test org.apache.hadoop.hive.ql.metadata.HiveException: Unable
to rename:
hdfs://10.18.40.99:9000/tmp/hive-root/hive_2011-06-27_11-59-52_522_5805414771967651042/-ext-10000
to: /test/test/test at
org.apache.hadoop.hive.ql.exec.MoveTask.moveFile(MoveTask.java:78)
at org.apache.hadoop.hive.ql.exec.MoveTask.execute(MoveTask.java:122)
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.service.HiveServer$HiveServerHandler.execute(HiveServer.java:116)
at
org.apache.hadoop.hive.service.ThriftHive$Processor$execute.process(ThriftHive.java:699)
at
org.apache.hadoop.hive.service.ThriftHive$Processor.process(ThriftHive.java:677)
at
org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:253)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
2011-06-27 12:00:15,384 ERROR ql.Driver (SessionState.java:printError(343)) -
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.MoveTask
{noformat}
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira