[HIVE-20966] Support bootstrap and incremental replication to a target with hive.strict.managed.tables enabled.

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Component/s: repl
• Labels: DR
• Target Version/s: 4.0.0
• Assignee: mahesh kumar behera
• Reporter: mahesh kumar behera
• Created: 25/Nov/18 12:41
• Updated: 10/Dec/18 12:12
• Resolved: 10/Dec/18 12:12

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.

Issue Links

• duplicates: HIVE-20884 Bootstrap of tables to target with hive.strict.managed.tables enabled.
• links to: GitHub Pull Request #500