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

["Ayush Saxena (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-26510?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17599680#comment-17599680 ] 

Ayush Saxena commented on HIVE-26510:
-------------------------------------

Committed to master.

Thanx [~sbadhya] for the contribution!!!

> Minor compaction creates empty delta files when no prior delta file 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
>              Labels: pull-request-available
>          Time Spent: 1.5h
>  Remaining Estimate: 0h
>
> 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)