[jira] [Commented] (HIVE-6406) Introduce immutable-table table property and if set, disallow insert-into

["Lefty Leverenz (JIRA)" <ji...@apache.org>]

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

Lefty Leverenz commented on HIVE-6406:
--------------------------------------

This is documented in the wiki in two places:

* [DML -- Inserting data into Hive tables from queries (see Synopsis after syntax) | https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML#LanguageManualDML-InsertingdataintoHiveTablesfromqueries]
* [DDL -- Create Table (see bullet list after syntax) | https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-CreateTable]

> Introduce immutable-table table property and if set, disallow insert-into
> -------------------------------------------------------------------------
>
>                 Key: HIVE-6406
>                 URL: https://issues.apache.org/jira/browse/HIVE-6406
>             Project: Hive
>          Issue Type: Sub-task
>          Components: HCatalog, Metastore, Query Processor, Thrift API
>            Reporter: Sushanth Sowmyan
>            Assignee: Sushanth Sowmyan
>             Fix For: 0.13.0
>
>         Attachments: HIVE-6406.2.patch, HIVE-6406.3.patch, HIVE-6406.patch
>
>
> As part of HIVE-6405's attempt to make HCatalog and Hive behave in similar ways with regards to immutable tables, this is a companion task to introduce the notion of an immutable table, wherein all tables are not immutable by default, and have this be a table property. If this property is set for a table, and we attempt to write to a table that already has data (or a partition), disallow "INSERT INTO" into it from hive(if destination directory is non-empty). This property being set will allow hive to mimic HCatalog's current immutable-table property.



--
This message was sent by Atlassian JIRA
(v6.2#6252)