Details
-
Improvement
-
Status: Patch Available
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
-
None
Description
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.