[HIVE-25724] Support External only tables for particular databases.

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: HiveServer2, Standalone Metastore
• Labels: pull-request-available
• Assignee: Sai Hemanth Gantasala
• Reporter: Sai Hemanth Gantasala
• Created: 19/Nov/21 05:26
• Updated: 17/Nov/22 08:47
• Resolved: 17/Dec/21 20:33

Description

Goal:
To be able to support disabling of ACID tables for a particular database.

Why?:
There is a use case to support BDR and hive3 replication engines in parallel. This can be used to avoid the creation of ACID tables in DBs replicated by the BDR engine. (BDR does not have the ability to replicate ACID tables)
Some users might want to use this as well for their legacy DBs while they transition to ACID tables in some newer DBs.

How?
A "special" property ("EXTERNAL_TABLES_ONLY" = "TRUE") to be set on the database. If this property is set, HMS will prevent the creation of ACID tables in this database.

Note:

1. Hive/HMS to implement the enforcement of this property in preventing table creation.
2. Hive/HMS will not prevent end-users from setting/tampering with this property.

Issue Links

• links to: GitHub Pull Request #2803