[ https://issues.apache.org/jira/browse/HIVE-21762?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sankar Hariappan updated HIVE-21762: ------------------------------------ Description: - REPL DUMP syntax: {code} REPL DUMP <repl_policy> [FROM <last_repl_id> WITH <key_values_list>; {code} - New format for the Replication policy have 3 parts all separated with Dot (.). 1. First part is DB name. 2. Second part is included list. Comma separated table names/regex with in square brackets[]. If square brackets are not there, then it is treated as single table replication which skips DB level events. 3. Third part is excluded list. Comma separated table names/regex with in square brackets[]. {code} <db_name> -- Full DB replication which is currently supported <db_name>.[*] - Full DB replication <db_name>.t1 -- Single table replication (DB events excluded) which is currently supported <db_name>.[t1, t2] -- DB replication with static list of tables t1 and t2 included. <db_name>.[t1*, t2, *t3].[t100, 5t3, t4] -- DB replication with all tables having prefix t1, with suffix t3 and include table t2 and exclude t100 which has the prefix t1, 5t3 which suffix t3 and t4. {code} - Need to support regular expression of any format. - A table is included in dump only if it matches the regular expressions in included list and doesn't match the excluded list. was: - REPL DUMP syntax: {code} REPL DUMP <repl_policy> [FROM <last_repl_id> WITH <key_values_list>; {code} - New format for the Replication policy have 3 parts all separated with Dot (.). 1. First part is DB name. 2. Second part is included list. Comma separated table names/regex with in square brackets[]. 3. Third part is excluded list. Comma separated table names/regex with in square brackets[]. {code} <db_name> -- Full DB replication which is currently supported <db_name>.[*] - Full DB replication <db_name>.t1 -- Single table replication (DB events excluded) which is currently supported <db_name>.[t1, t2] -- DB replication with static list of tables t1 and t2 included. <db_name>.[t1*, t2, *t3].[t100, 5t3, t4] -- DB replication with all tables having prefix t1, with suffix t3 and include table t2 and exclude t100 which has the prefix t1, 5t3 which suffix t3 and t4. {code} - Need to support regular expression of any format. - A table is included in dump only if it matches the regular expressions in included list and doesn't match the excluded list. > REPL DUMP to support new format for replication policy input to take included > tables list. > ------------------------------------------------------------------------------------------ > > Key: HIVE-21762 > URL: https://issues.apache.org/jira/browse/HIVE-21762 > Project: Hive > Issue Type: Sub-task > Components: repl > Reporter: Sankar Hariappan > Assignee: Sankar Hariappan > Priority: Major > Labels: DR, Replication > Attachments: HIVE-21762.01.patch > > > - REPL DUMP syntax: > {code} > REPL DUMP <repl_policy> [FROM <last_repl_id> WITH <key_values_list>; > {code} > - New format for the Replication policy have 3 parts all separated with Dot > (.). > 1. First part is DB name. > 2. Second part is included list. Comma separated table names/regex with in > square brackets[]. If square brackets are not there, then it is treated as > single table replication which skips DB level events. > 3. Third part is excluded list. Comma separated table names/regex with in > square brackets[]. > {code} > <db_name> -- Full DB replication which is currently supported > <db_name>.[*] - Full DB replication > <db_name>.t1 -- Single table replication (DB events excluded) which is > currently supported > <db_name>.[t1, t2] -- DB replication with static list of tables t1 and t2 > included. > <db_name>.[t1*, t2, *t3].[t100, 5t3, t4] -- DB replication with all tables > having prefix t1, with suffix t3 and include table t2 and exclude t100 which > has the prefix t1, 5t3 which suffix t3 and t4. > {code} > - Need to support regular expression of any format. > - A table is included in dump only if it matches the regular expressions in > included list and doesn't match the excluded list. -- This message was sent by Atlassian JIRA (v7.6.3#76005)