[HIVE-23586] load data overwrite into bucket table failed

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: 3.1.0, 3.1.2, 4.0.0
• Component/s: HiveServer2
• Labels: pull-request-available
• Target Version/s: 4.1.0
• Assignee: zhaolong
• Reporter: zhaolong
• Created: 01/Jun/20 13:13
• Updated: 06/Apr/24 09:53

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');

load data inpath 'hdfs://hacluster/tmp/zltest' overwrite into table default.test_hive2 partition (logdate='20200508');// should overwrite but insert new data

Issue Links

• links to: GitHub Pull Request #1048