hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Anthony Hsu (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-15411) ADD PARTITION should support setting FILEFORMAT and SERDEPROPERTIES
Date Thu, 15 Dec 2016 00:55:58 GMT

     [ https://issues.apache.org/jira/browse/HIVE-15411?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Anthony Hsu updated HIVE-15411:
-------------------------------
    Status: Patch Available  (was: Open)

Uploaded patch. Also created RB here: https://reviews.apache.org/r/54765/

> 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
>         Attachments: HIVE-15411.1.patch
>
>
> 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)

Mime
View raw message