External Tables should have the option to be marked Read Only
-------------------------------------------------------------

                 Key: HIVE-335
                 URL: https://issues.apache.org/jira/browse/HIVE-335
             Project: Hadoop 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 is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to