[
https://issues.apache.org/jira/browse/HIVE-22158?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16961101#comment-16961101
]
Naveen Gangam commented on HIVE-22158:
--------------------------------------
[~gaborkaszab] An external table can be converted to an ACID MANAGED table via
an {{alter table}} query. To do so, alter table needs to change TBLPROPERTIES
to set EXTERNAL=FALSE, transactional=true or
transactional_propeties=insert_only, location=<location within managed
warehouse>.
Hope this helps. Let me know if you have further questions. Thanks
> HMS Translation layer - Disallow non-ACID MANAGED tables.
> ---------------------------------------------------------
>
> Key: HIVE-22158
> URL: https://issues.apache.org/jira/browse/HIVE-22158
> Project: Hive
> Issue Type: Sub-task
> Components: Hive
> Affects Versions: 4.0.0
> Reporter: Naveen Gangam
> Assignee: Naveen Gangam
> Priority: Major
> Fix For: 4.0.0
>
> Attachments: HIVE-22158.1.patch, HIVE-22158.1.patch,
> HIVE-22158.2.patch
>
>
> In the recent commits, we have allowed non-ACID MANAGED tables to be created
> by clients that have some form of ACID WRITE capabilities.
> I think it would make sense to disallow this entirely. MANAGED tables should
> be ACID tables only.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
