Return-Path: <issues-return-60715-archive-asf-public=cust-asf.ponee.io@hive.apache.org>
X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io
Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io
Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183])
	by cust-asf2.ponee.io (Postfix) with ESMTP id 424BB200BE5
	for <archive-asf-public-internal@cust-asf2.ponee.io>; Fri,  9 Dec 2016 22:24:00 +0100 (CET)
Received: by cust-asf.ponee.io (Postfix)
	id 40E0E160B2A; Fri,  9 Dec 2016 21:24:00 +0000 (UTC)
Delivered-To: archive-asf-public@cust-asf.ponee.io
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by cust-asf.ponee.io (Postfix) with SMTP id 92FF9160AFD
	for <archive-asf-public@cust-asf.ponee.io>; Fri,  9 Dec 2016 22:23:59 +0100 (CET)
Received: (qmail 24439 invoked by uid 500); 9 Dec 2016 21:23:58 -0000
Mailing-List: contact issues-help@hive.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:issues-help@hive.apache.org>
List-Unsubscribe: <mailto:issues-unsubscribe@hive.apache.org>
List-Post: <mailto:issues@hive.apache.org>
List-Id: <issues.hive.apache.org>
Reply-To: dev@hive.apache.org
Delivered-To: mailing list issues@hive.apache.org
Received: (qmail 24413 invoked by uid 99); 9 Dec 2016 21:23:58 -0000
Received: from arcas.apache.org (HELO arcas) (140.211.11.28)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 09 Dec 2016 21:23:58 +0000
Received: from arcas.apache.org (localhost [127.0.0.1])
	by arcas (Postfix) with ESMTP id ACA362C03DE
	for <issues@hive.apache.org>; Fri,  9 Dec 2016 21:23:58 +0000 (UTC)
Date: Fri, 9 Dec 2016 21:23:58 +0000 (UTC)
From: "Anthony Hsu (JIRA)" <jira@apache.org>
To: issues@hive.apache.org
Message-ID: <JIRA.13027101.1481318354000.486777.1481318638703@Atlassian.JIRA>
In-Reply-To: <JIRA.13027101.1481318354000@Atlassian.JIRA>
References: <JIRA.13027101.1481318354000@Atlassian.JIRA> <JIRA.13027101.1481318354221@arcas>
Subject: [jira] [Commented] (HIVE-15411) ADD PARTITION should support
 setting FILEFORMAT and SERDEPROPERTIES
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394
archived-at: Fri, 09 Dec 2016 21:24:00 -0000


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

Anthony Hsu commented on HIVE-15411:
------------------------------------

Proposal is to extend the ADD PARTITION grammar to support the following:
{noformat}
ALTER TABLE table_name ADD [IF NOT EXISTS]
PARTITION (part_col='part_value', ...)
  [FILEFORMAT <format>]                  -- new
  [SERDEPROPERTIES ('key1'='val', ...)]  -- new
  [LOCATION 'location1']
PARTITION (part_col='part_value', ...)
  [FILEFORMAT <format>]                  -- new
  [SERDEPROPERTIES ('key1'='val', ...)]  -- new
  [LOCATION 'location2']
...;
{noformat}

> ADD PARTITION should support setting FILEFORMAT and SERDEPROPERTIES
> -------------------------------------------------------------------
>
>                 Key: HIVE-15411
>                 URL: https://issues.apache.org/jira/browse/HIVE-15411
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Anthony Hsu
>            Assignee: Anthony Hsu
>
> Currently, {{ALTER TABLE ... ADD PARTITION}} only lets you set the partition's LOCATION but not its FILEFORMAT or SERDEPROPERTIES. In order to change the FILEFORMAT or SERDEPROPERTIES, you have to issue two additional calls to {{ALTER TABLE ... PARTITION ... SET FILEFORMAT}} and {{ALTER TABLE ... PARTITION ... SET SERDEPROPERTIES}}. This is not atomic, and queries that interleave the ALTER TABLE commands may fail.
> We should extend the grammar to support setting FILEFORMAT and SERDEPROPERTIES atomically as part of the ADD PARTITION command.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)