[
https://issues.apache.org/jira/browse/HIVE-1975?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13103707#comment-13103707
]
Chinna Rao Lalam commented on HIVE-1975:
----------------------------------------
Use case is if we want to insert into multilevel directory like
'/HIVEFT25686/chinna/'
(insert overwrite directory '/HIVEFT25686/chinna/' select * from dept_j) this
is failing because "fs.rename(sourcePath, targetPath)" is failing rename to
multilevel directories, so first created the target path.
>> But users misspell the dir name, they may not want the dirs created.Or
>> worse, the data got loaded to some other place they not noticed.
This one will happen in the normal scenario also what ever the location user
specifies it will move the data to that location.
But as u said if the rename operation fails it should delete the created
directory. I will update the patch with this case.
> "insert overwrite directory" Not able to insert data with multi level
> directory path
> ------------------------------------------------------------------------------------
>
> Key: HIVE-1975
> URL: https://issues.apache.org/jira/browse/HIVE-1975
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Affects Versions: 0.5.0
> Environment: Hadoop 0.20.1, Hive0.5.0 and SUSE Linux Enterprise
> Server 10 SP2 (i586) - Kernel 2.6.16.60-0.21-smp (5).
> Reporter: Chinna Rao Lalam
> Assignee: Chinna Rao Lalam
> Attachments: HIVE-1975.patch
>
>
> Below query execution is failed
> Ex:
> {noformat}
> insert overwrite directory '/HIVEFT25686/chinna/' select * from dept_j;
> {noformat}
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
