[ https://issues.apache.org/jira/browse/HIVE-2265?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13147523#comment-13147523 ]
Chinna Rao Lalam commented on HIVE-2265: ---------------------------------------- Pls check this issue resolved by HIVE-1975 then we can close this issue as duplicate issue of HIVE-1975 > "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.0, 0.7.1 > 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. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira