[
https://issues.apache.org/jira/browse/HIVE-25724?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sai Hemanth Gantasala updated HIVE-25724:
-----------------------------------------
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:
# 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.
was:
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 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.
> 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
>
> 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)
