[
https://issues.apache.org/jira/browse/HIVE-20131?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
mahesh kumar behera updated HIVE-20131:
---------------------------------------
Description:
1. Change partion name size from 1024 to 767 . (mySQL 5.6 and before that
supports max 767 length keys)
2. Remove the create txn_write_notification_log table creation from 3.1.0
scripts and add a new scripts for 3.2.0
3. Remove the file 3.1.0-to-4.0.0 and instead add file for 3.2.0-to-4.0.0 and
3.1.0-to-3.2.0
4. Change in metastore init schema xml file to take 4.0.0 instead of 3.1.0 as
current version.
h1.
was:
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).
> 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
>
>
> 1. Change partion name size from 1024 to 767 . (mySQL 5.6 and before that
> supports max 767 length keys)
> 2. Remove the create txn_write_notification_log table creation from 3.1.0
> scripts and add a new scripts for 3.2.0
> 3. Remove the file 3.1.0-to-4.0.0 and instead add file for 3.2.0-to-4.0.0 and
> 3.1.0-to-3.2.0
> 4. Change in metastore init schema xml file to take 4.0.0 instead of 3.1.0
> as current version.
> h1.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
