[
https://issues.apache.org/jira/browse/HIVE-25724?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated HIVE-25724:
----------------------------------
Labels: pull-request-available (was: )
> 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
> Time Spent: 10m
> 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)
