[jira] [Comment Edited] (HIVE-17562) ACID 1.0 + ETL strategy should treat empty compacted files as uncovered deltas

["Prasanth Jayachandran (JIRA)" <ji...@apache.org>]

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

Prasanth Jayachandran edited comment on HIVE-17562 at 10/5/17 5:53 PM:
-----------------------------------------------------------------------

Committed to branch-2, branch-2.2, branch-2.3. Thanks for the review!


was (Author: prasanth_j):
Committed to branch-2. Thanks for the review!

> ACID 1.0 + ETL strategy should treat empty compacted files as uncovered deltas
> ------------------------------------------------------------------------------
>
>                 Key: HIVE-17562
>                 URL: https://issues.apache.org/jira/browse/HIVE-17562
>             Project: Hive
>          Issue Type: Bug
>          Components: Transactions
>    Affects Versions: 2.4.0
>            Reporter: Prasanth Jayachandran
>            Assignee: Prasanth Jayachandran
>             Fix For: 2.4.0, 2.2.1, 2.3.1
>
>         Attachments: HIVE-17562.1.branch-2.patch, HIVE-17562-branch-2.patch, HIVE-17562-branch-2.patch
>
>
> In branch-2, with ACID 1.0, following sequence will result in incorrect results
> 1) Set split strategy to ETL
> 2) Insert some rows
> 3) Delete all rows
> 4) Alter table compact MAJOR
> 5) Insert some rows
> 6) Select * query will not return any rows that is written at last (step 5)
> The reason for that, compaction essentially voids the first insert in step 2. Now when ETL split strategy is chosen, there will not be any stripes in the base files. So no split gets generated and any subsequent deltas gets ignored.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)