[HIVE-26510] Minor compaction creates empty delta files when no prior delta file exists

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-2
• Labels: pull-request-available
• Hadoop Flags: Reviewed
• Assignee: Sourabh Badhya
• Reporter: Sourabh Badhya
• Created: 01/Sep/22 08:08
• Updated: 16/Nov/22 13:50
• Resolved: 02/Sep/22 19:04

Description

Hive is creating empty delta files after minor compaction even when 0 delta files exists before compaction.

Steps to reproduce:

DROP TABLE IF EXISTS test_major_delete_minor;
CREATE TABLE test_major_delete_minor (name VARCHAR(50), age TINYINT, num_clicks BIGINT) stored as orc;
insert into test_major_delete_minor values ('amy', 35, 12341234);
insert into test_major_delete_minor values ('bob', 66, 1234712348712);
insert into test_major_delete_minor values ('cal', 21, 431);
insert into test_major_delete_minor values ('fse', 28, 8456);
ALTER TABLE test_major_delete_minor  COMPACT 'major';
DELETE FROM test_major_delete_minor WHERE name='bob';
DELETE FROM test_major_delete_minor WHERE name='fse';
ALTER TABLE test_major_delete_minor  COMPACT 'minor'; 

Issue Links

• links to: GitHub Pull Request #3568