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

Steve Yeom edited comment on HIVE-18693 at 2/28/18 2:29 AM:
------------------------------------------------------------

Talked with Eugene.
The patch has the following requirements: 
1. Allow Snapshot Isolation to work. Esp., we should keep TXNS row for aborted 
transaction until the related delta directories
  are removed (which can contain many components). For this we will add rows 
for components (partitions/table)
  intoTXN_COMPONENTS. 
2. Remove aborted transaction delta/base directories for MM tables.
3. Still the states of a compaction for MM table is INITIATED, IN-PROGRESS, 
COMPACTED, 
READY-FOR-CLEANING, and CLEANED until parallelism is introduced for Worker.
4. Clean obsolete directories, and Metastore metadata rows for transaction 
tables. 
 


was (Author: steveyeom2017):
Talked with Eugene.
The patch has the following requirements: 
1. Allow Snapshot Isolation to work. Esp., we should keep TXNS row for aborted 
transaction until the related delta directories
  are removed (which can contain many components). For this we will add rows 
for components (partitions/table)
  intoTXN_COMPONENTS. 
2. Remove aborted transaction delta/base directories for MM tables.
3. Do not initiate compaction for MM tables. So a compaction request for MM 
table may have 
  INITIATING/INITIATED, CLEANING, FINISHED state without COMPACTING/COMPACTED 
state.
3. Clean obsolete directories, and Metastore metadata rows for transaction 
tables. 
 

> Snapshot Isolation does not work for Micromanaged table when a insert 
> transaction is aborted
> --------------------------------------------------------------------------------------------
>
>                 Key: HIVE-18693
>                 URL: https://issues.apache.org/jira/browse/HIVE-18693
>             Project: Hive
>          Issue Type: Bug
>          Components: Transactions
>            Reporter: Steve Yeom
>            Assignee: Steve Yeom
>            Priority: Major
>         Attachments: HIVE-18693.01.patch
>
>
> TestTxnCommands2#writeBetweenWorkerAndCleaner with minor 
> changes (changing delete command to insert command) fails on MM table.
> Specifically the last SELECT commands returns wrong results. 
> But this test works fine with full ACID table. 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to