hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Koehnlein (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-335) External Tables should have the option to be marked Read Only
Date Thu, 02 May 2013 14:06:16 GMT

    [ https://issues.apache.org/jira/browse/HIVE-335?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13647542#comment-13647542
] 

Michael Koehnlein commented on HIVE-335:
----------------------------------------

This would be useful for me, too. We have data on HDFS that belongs to a system user account,
and our "normal" users should be able analyze it as an external table. As it is now, the users
would need HDFS write permissions on the data directory if they want to create an external
table for that directory themselves, although they really only need read permissions. Of course
that's not a big obstacle, since we can just let the system user create the external table.
It certainly would be nice to get pure read access via external tables, though.
                
> 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

Mime
View raw message