[ https://issues.apache.org/jira/browse/HIVE-20966?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sankar Hariappan updated HIVE-20966: ------------------------------------ Description: *Requirements:* Hive2 supports replication of managed tables. But in Hive3 with hive.strict.managed.tables=true, some of these managed tables are converted to ACID or MM tables. Also, some of them are converted to external tables based on below rules. - Avro format with external schema, Storage handlers, List bucketed tabled are converted to external tables. - Location not owned by "hive" user are converted to external table. - Hive owned ORC format are converted to full ACID transactional table. - Hive owned Non-ORC format are converted to MM transactional table. REPL LOAD should apply these rules during bootstrap and incremental phases and convert the tables accordingly. was: *Requirements:* Hive2 supports replication of managed tables. But in Hive3, some of these managed tables are converted to ACID or MM tables. Also, some of them are converted to external tables based on below rules. - Avro format with external schema, Storage handlers, List bucketed tabled are converted to external tables. - Location not owned by "hive" user are converted to external table. - Hive owned ORC format are converted to full ACID transactional table. - Hive owned Non-ORC format are converted to MM transactional table. REPL LOAD should apply these rules during bootstrap and incremental phases and convert the tables accordingly. > Support bootstrap and incremental replication to a target with > hive.strict.managed.tables enabled. > -------------------------------------------------------------------------------------------------- > > Key: HIVE-20966 > URL: https://issues.apache.org/jira/browse/HIVE-20966 > Project: Hive > Issue Type: Sub-task > Components: repl > Affects Versions: 4.0.0 > Reporter: mahesh kumar behera > Assignee: mahesh kumar behera > Priority: Major > Labels: DR > > *Requirements:* > Hive2 supports replication of managed tables. But in Hive3 with > hive.strict.managed.tables=true, some of these managed tables are converted > to ACID or MM tables. Also, some of them are converted to external tables > based on below rules. > - Avro format with external schema, Storage handlers, List bucketed tabled > are converted to external tables. > - Location not owned by "hive" user are converted to external table. > - Hive owned ORC format are converted to full ACID transactional table. > - Hive owned Non-ORC format are converted to MM transactional table. > REPL LOAD should apply these rules during bootstrap and incremental phases > and convert the tables accordingly. -- This message was sent by Atlassian JIRA (v7.6.3#76005)