hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Johan Oskarsson (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-335) External Tables should have the option to be marked Read Only
Date Wed, 12 Aug 2009 16:43:14 GMT

    [ 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.


Mime
View raw message