hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "mahesh kumar behera (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-20131) SQL Script changes for creating txn write notification in 3.2.0 files
Date Tue, 10 Jul 2018 05:30:00 GMT

     [ https://issues.apache.org/jira/browse/HIVE-20131?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

mahesh kumar behera updated HIVE-20131:
---------------------------------------
    Attachment: HIVE-20131.01.patch

> SQL Script changes for creating  txn write notification in 3.2.0 files 
> -----------------------------------------------------------------------
>
>                 Key: HIVE-20131
>                 URL: https://issues.apache.org/jira/browse/HIVE-20131
>             Project: Hive
>          Issue Type: Sub-task
>          Components: repl, Transactions
>    Affects Versions: 3.0.0
>            Reporter: mahesh kumar behera
>            Assignee: mahesh kumar behera
>            Priority: Major
>              Labels: ACID, DR, pull-request-available, replication
>             Fix For: 4.0.0
>
>
>  
> h1. Replicate ACID write Events
>  * Create new EVENT_WRITE event with related message format to log the write operations
with in a txn along with data associated.
>  * Log this event when perform any writes (insert into, insert overwrite, load table,
delete, update, merge, truncate) on table/partition.
>  * If a single MERGE/UPDATE/INSERT/DELETE statement operates on multiple partitions,
then need to log one event per partition.
>  * DbNotificationListener should log this type of event to special metastore table named
"MTxnWriteNotificationLog".
>  * This table should maintain a map of txn ID against list of tables/partitions written
by given txn.
>  * The entry for a given txn should be removed by the cleaner thread that removes the
expired events from EventNotificationTable.
> h1. Replicate Commit Txn operation (with writes)
> Add new EVENT_COMMIT_TXN to log the metadata/data of all tables/partitions modified within
the txn.
> *Source warehouse:*
>  * This event should read the EVENT_WRITEs from "MTxnWriteNotificationLog" metastore
table to consolidate the list of tables/partitions modified within this txn scope.
>  * Based on the list of tables/partitions modified and table Write ID, need to compute
the list of delta files added by this txn.
>  * Repl dump should read this message and dump the metadata and delta files list.
> *Target warehouse:*
>  * Ensure snapshot isolation at target for on-going read txns which shouldn't view the
data replicated from committed txn. (Ensured with open and allocate write ID events).



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

Mime
View raw message