[ https://issues.apache.org/jira/browse/HIVE-335?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13718636#comment-13718636 ]
Lance Norskog commented on HIVE-335: ------------------------------------ The user security trick will be good enough for us, but, yes, the ability to avoid destroying data would be very helpful. > 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 is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira