Return-Path: X-Original-To: apmail-hive-dev-archive@www.apache.org Delivered-To: apmail-hive-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 33B9910769 for ; Thu, 20 Feb 2014 07:55:35 +0000 (UTC) Received: (qmail 13921 invoked by uid 500); 20 Feb 2014 07:55:28 -0000 Delivered-To: apmail-hive-dev-archive@hive.apache.org Received: (qmail 13778 invoked by uid 500); 20 Feb 2014 07:55:26 -0000 Mailing-List: contact dev-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list dev@hive.apache.org Received: (qmail 13579 invoked by uid 500); 20 Feb 2014 07:55:23 -0000 Delivered-To: apmail-hadoop-hive-dev@hadoop.apache.org Received: (qmail 13499 invoked by uid 99); 20 Feb 2014 07:55:22 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 20 Feb 2014 07:55:22 +0000 Date: Thu, 20 Feb 2014 07:55:22 +0000 (UTC) From: "Lefty Leverenz (JIRA)" To: hive-dev@hadoop.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (HIVE-6406) Introduce immutable-table table property and if set, disallow insert-into MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/HIVE-6406?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13906726#comment-13906726 ] Lefty Leverenz commented on HIVE-6406: -------------------------------------- This needs documentation -- how about a release note for starters? (Of course HIVE-6465 will also need documentation after it's committed.) Table properties are inadequately documented in the wiki -- see my Feb. 14th message to dev@hive: * [User doc for table properties |http://mail-archives.apache.org/mod_mbox/hive-dev/201402.mbox/%3cCACEcauVSQt1TCrKg=_Oqr2NQSe5AuX7xuZbxcCNX-mLNCo4r-w@mail.gmail.com%3e] > 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.1.5#6160)