[
https://issues.apache.org/jira/browse/HIVE-14560?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16256270#comment-16256270
]
Ashutosh Chauhan commented on HIVE-14560:
-----------------------------------------
+1
> Support exchange partition between s3 and hdfs tables
> -----------------------------------------------------
>
> Key: HIVE-14560
> URL: https://issues.apache.org/jira/browse/HIVE-14560
> Project: Hive
> Issue Type: Bug
> Reporter: Abdullah Yousufi
> Assignee: Abdullah Yousufi
> Fix For: 3.0.0
>
> Attachments: HIVE-14560.02.patch, HIVE-14560.patch
>
>
> {code}
> alter table s3_tbl exchange partition (country='USA', state='CA') with table
> hdfs_tbl;
> {code}
> results in:
> {code}
> Error: Error while processing statement: FAILED: Execution Error, return code
> 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Got
> exception: java.lang.IllegalArgumentException Wrong FS:
> s3a://hive-on-s3/s3_tbl/country=USA/state=CA, expected:
> hdfs://localhost:9000) (state=08S01,code=1)
> {code}
> because the check for whether the s3 destination table path exists occurs on
> the hdfs filesystem.
> Furthermore, exchanging between s3 to hdfs fails because the hdfs rename
> operation is not supported across filesystems. Fix uses copy + deletion in
> the case that the file systems differ.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
