You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Sourabh Badhya (Jira)" <ji...@apache.org> on 2022/09/01 08:09:00 UTC

[jira] [Created] (HIVE-26510) Minor compaction creates empty delta files when no prior delta files exists

Sourabh Badhya created HIVE-26510:
-------------------------------------

             Summary: Minor compaction creates empty delta files when no prior delta files exists
                 Key: HIVE-26510
                 URL: https://issues.apache.org/jira/browse/HIVE-26510
             Project: Hive
          Issue Type: Bug
            Reporter: Sourabh Badhya
            Assignee: Sourabh Badhya


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

Steps to reproduce:
{code:java}
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'; {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)