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

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-25724?focusedWorklogId=698099&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-698099 ]

ASF GitHub Bot logged work on HIVE-25724:
-----------------------------------------

                Author: ASF GitHub Bot
            Created on: 17/Dec/21 20:32
            Start Date: 17/Dec/21 20:32
    Worklog Time Spent: 10m 
      Work Description: nrg4878 commented on pull request #2803:
URL: https://github.com/apache/hive/pull/2803#issuecomment-997014973


   fix has been committed to master. Please close the PR.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Issue Time Tracking
-------------------

    Worklog Id:     (was: 698099)
    Time Spent: 20m  (was: 10m)

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