"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

        

Reply via email to