[jira] [Commented] (HIVE-335) External Tables should have the option to be marked Read Only

["Matt Pollock (JIRA)" <ji...@apache.org>]

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

Matt Pollock commented on HIVE-335:
-----------------------------------

My organization has lots of data producing users/accounts and not all data producers are hive users. It would be extremely valuable to be able to create a read-only external table to avoid data copy and enable flexible query on data the consumer did not produce but has read access to.

> 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
>
> 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
(v6.3.4#6332)