[
https://issues.apache.org/jira/browse/HIVE-25724?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Naveen Gangam resolved HIVE-25724.
----------------------------------
Fix Version/s: 4.0.0
Resolution: Fixed
Fix has been committed to master. Thank you for the patch [~hemanth619]
> Support External only tables for particular databases.
> ------------------------------------------------------
>
> Key: HIVE-25724
> URL: https://issues.apache.org/jira/browse/HIVE-25724
> Project: Hive
> Issue Type: Improvement
> Components: HiveServer2, Standalone Metastore
> Reporter: Sai Hemanth Gantasala
> Assignee: Sai Hemanth Gantasala
> Priority: Major
> Labels: pull-request-available
> Fix For: 4.0.0
>
> Time Spent: 20m
> Remaining Estimate: 0h
>
> 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:
> # Hive/HMS to implement the enforcement of this property in preventing table
> creation.
> # Hive/HMS will not prevent end-users from setting/tampering with this
> property.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
