[jira] [Created] (HIVE-15411) ADD PARTITION should support setting FILEFORMAT and SERDEPROPERTIES

["Anthony Hsu (JIRA)" <ji...@apache.org>]

Anthony Hsu created HIVE-15411:
----------------------------------

             Summary: 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)