[
https://issues.apache.org/jira/browse/HIVE-23586?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
zhaolong updated HIVE-23586:
----------------------------
Description:
load data overwrite into bucket table is failed if filename is not like
000000_0, but insert new data in the table.
for example:
CREATE EXTERNAL TABLE IF NOT EXISTS test_hive2 (name string,account string)
PARTITIONED BY (logdate string) CLUSTERED BY (account) INTO 4 BUCKETS row
format delimited fields terminated by '|' STORED AS textfile;
load data inpath 'hdfs://hacluster/tmp/zltest' overwrite into table
default.test_hive2 partition (logdate='20200508');
!image-2020-06-01-21-40-21-726.png!
load data inpath 'hdfs://hacluster/tmp/zltest' overwrite into table
default.test_hive2 partition (logdate='20200508');// should overwrite but
insert new data
!image-2020-06-01-21-41-28-732.png!
was:
load data overwrite into bucket table is failed if filename is not like
000000_0, but insert new data in the table.
for example:
CREATE EXTERNAL TABLE IF NOT EXISTS test_hive2 (name string,account string)
PARTITIONED BY (logdate string) CLUSTERED BY (account) INTO 4 BUCKETS row
format delimited fields terminated by '|' STORED AS textfile;
load data inpath 'hdfs://hacluster/tmp/zltest' overwrite into table
default.test_hive2 partition (logdate='20200508');
!image-2020-06-01-21-40-21-726.png!
load data inpath 'hdfs://hacluster/tmp/zltest' overwrite into table
default.test_hive2 partition (logdate='20200508');// should overwrite buf
insert new data
!image-2020-06-01-21-41-28-732.png!
> load data overwrite into bucket table failed
> --------------------------------------------
>
> Key: HIVE-23586
> URL: https://issues.apache.org/jira/browse/HIVE-23586
> Project: Hive
> Issue Type: Bug
> Affects Versions: 3.1.0, 3.1.2
> Reporter: zhaolong
> Priority: Critical
> Attachments: image-2020-06-01-21-40-21-726.png,
> image-2020-06-01-21-41-28-732.png
>
>
> load data overwrite into bucket table is failed if filename is not like
> 000000_0, but insert new data in the table.
>
> for example:
> CREATE EXTERNAL TABLE IF NOT EXISTS test_hive2 (name string,account string)
> PARTITIONED BY (logdate string) CLUSTERED BY (account) INTO 4 BUCKETS row
> format delimited fields terminated by '|' STORED AS textfile;
> load data inpath 'hdfs://hacluster/tmp/zltest' overwrite into table
> default.test_hive2 partition (logdate='20200508');
> !image-2020-06-01-21-40-21-726.png!
> load data inpath 'hdfs://hacluster/tmp/zltest' overwrite into table
> default.test_hive2 partition (logdate='20200508');// should overwrite but
> insert new data
> !image-2020-06-01-21-41-28-732.png!
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
