You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Sourabh Badhya (Jira)" <ji...@apache.org> on 2022/09/01 08:10:00 UTC
[jira] [Work started] (HIVE-26510) Minor compaction creates empty delta files when no prior delta files exists
[ https://issues.apache.org/jira/browse/HIVE-26510?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Work on HIVE-26510 started by Sourabh Badhya.
---------------------------------------------
> 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
> Priority: Minor
>
> 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)