zhixingheyi-tian created HIVE-27970:
---------------------------------------
Summary: Single Hive/Datasource table partitioning to multiple
storage system- (e.g, S3 and HDFS)
Key: HIVE-27970
URL: https://issues.apache.org/jira/browse/HIVE-27970
Project: Hive
Issue Type: Improvement
Affects Versions: 3.1.2
Reporter: zhixingheyi-tian
Single Hive/Datasource table partitioning to multiple storage system- (e.g, S3
and HDFS)
For Hive table:
{code:java}
CREATE TABLE htable a string, b string) PARTITIONED BY ( p string ) location
"hdfs://{cluster}}/user/hadoop/htable/";
alter table htable add partition(p='p1') location
's3a://{bucketname}/usr/hive/warehouse/htable/p=p1';
{code}
When inserting into htable, or insert overwrite htable. New data of “p=p1”
will insert table location storage. This does not meet the requirements.
Is there any best practise? Or is there a plan to support this feature?
Thanks!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
