[jira] [Commented] (HIVE-22158) HMS Translation layer - Disallow non-ACID MANAGED tables.

["Rui Li (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-22158?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16971481#comment-16971481 ] 

Rui Li commented on HIVE-22158:
-------------------------------

Hi [~ngangam], I recently hit some issue with this change. When I create some non-ACID tables, they get silently converted to external tables. And if I try to insert data into these tables, I get exception that {{"An external table's location should not be located within managed warehouse root directory"}}. So it doesn't seem very user friendly to me. Any thoughts?

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