[jira] [Resolved] (HIVE-25724) Support External only tables for particular databases.

["Naveen Gangam (Jira)" <ji...@apache.org>]

     [ 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)