You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Bharathkrishna Guruvayoor Murali (JIRA)" <ji...@apache.org> on 2018/08/08 20:43:00 UTC
[jira] [Commented] (HIVE-335) External Tables should have the
option to be marked Read Only
[ https://issues.apache.org/jira/browse/HIVE-335?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16573838#comment-16573838 ]
Bharathkrishna Guruvayoor Murali commented on HIVE-335:
-------------------------------------------------------
I was looking at this JIRA, and found that there is HiveConf.HIVE_INSERT_INTO_EXTERNAL_TABLES which determines _whether insert into external tables is allowed._
So does this Jira mean we need certain tables to behave READONLY irrespective of this configuration value?
> External Tables should have the option to be marked Read Only
> -------------------------------------------------------------
>
> Key: HIVE-335
> URL: https://issues.apache.org/jira/browse/HIVE-335
> Project: Hive
> Issue Type: Improvement
> Components: Metastore, Query Processor
> Reporter: Richard Lee
> Priority: Major
>
> When creating an External Table, it'd be awesome to have the option of NOT allowing writes to it (disallow any INSERTs or if hive ever allows UPDATEs). Adding and Dropping Partitions should still be allowed.
> This will enable hive to "play well" with external data stores other than hdfs where data should be non-maleable.
> I'd recomend the following syntax, which applies ONLY to external tables:
> CREATE EXTERNAL [READONLY] TABLE ...
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)