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