Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Wed, 24 Jul 2013 17:55:49 +0000 (UTC)
From: "Lance Norskog (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: <JIRA.12416566.1236708498759.105173.1374688549193@arcas>
In-Reply-To: <JIRA.12416566.1236708498759@arcas>
References: <JIRA.12416566.1236708498759@arcas>
Subject: [jira] [Commented] (HIVE-335) External Tables should have the
 option to be marked Read Only
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ 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