Abdullah Yousufi created HIVE-14560:
---------------------------------------

             Summary: 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: 2.2.0


{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.3.4#6332)

Reply via email to