You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Richard Lee (JIRA)" <ji...@apache.org> on 2009/03/10 19:08:51 UTC
[jira] Created: (HIVE-335) External Tables should have the option
to be marked Read Only
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.
[jira] Commented: (HIVE-335) External Tables should have the option
to be marked Read Only
Posted by "Johan Oskarsson (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-335?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12742442#action_12742442 ]
Johan Oskarsson commented on HIVE-335:
--------------------------------------
I agree that this would be very useful. I could try to spend some time on implementing this in the near future unless there are preferred solutions to the "don't overwrite our precious data" problem. HDFS permissions are a help but not everyone uses them and there is still the risk when running as the superuser.
> 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.