[ 
https://issues.apache.org/jira/browse/HIVE-15856?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15860388#comment-15860388
 ] 

Sahil Takiar commented on HIVE-15856:
-------------------------------------

Hey [~poeppt], sounds good. I haven't done much for writing the qtests yet, 
just started today. So if you have been working on this, that sounds good to 
me. I will make this JIRA dependent on HIVE-15867.

For reference, this is what I wrote earlier today:

{code}
create table hdfs_src (col1 int, col2 int, col3 int);
insert into table hdfs_src values (1, 2, 3), (4, 5, 6), (7, 8, 9);

create table blobstore_src location 
'${hiveconf:test.blobstore.path.unique}/exim/blobstore_src' as select * from 
hdfs_src;

-- Test export HDFS to blobstore, and then import blobstore to HDFS

export table hdfs_src to 
'${hiveconf:test.blobstore.path.unique}/exim/export_from_hdfs';
import table imported_from_hdfs from 
'${hiveconf:test.blobstore.path.unique}/exim/export_from_hdfs';
select * from imported_from_hdfs;

-- Test export blobstore to blobstore, and then import blobstore to blobstore

export table blobstore_src to 
'${hiveconf:test.blobstore.path.unique}/exim/export_from_blobstore';
import table imported_from_blobstore from 
'${hiveconf:test.blobstore.path.unique}/exim/export_from_blobstore'; 
select * from imported_from_blobstore;

-- Test export blobstore to HDFS, and then import HDFS to blobstore

export table blobstore_src to 
'${hiveconf:hive.metastore.warehouse.dir}/export_from_blobstore';
import table imported_from_hdfs from 
'${hiveconf:hive.metastore.warehouse.dir}/blobstore_src_hdfs' location 
'${hiveconf:test.blobstore.path.unique}/exim/imported_from_hdfs';
select * from imported_from_hdfs;
{code}

> Hive export/import (hive.exim.uri.scheme.whitelist) to support s3a
> ------------------------------------------------------------------
>
>                 Key: HIVE-15856
>                 URL: https://issues.apache.org/jira/browse/HIVE-15856
>             Project: Hive
>          Issue Type: Bug
>          Components: Hive
>            Reporter: Sahil Takiar
>            Assignee: Sahil Takiar
>
> Add support for export / import operations on S3.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Reply via email to