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)
