[
https://issues.apache.org/jira/browse/HIVE-12414?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17372619#comment-17372619
]
dzcxzl commented on HIVE-12414:
-------------------------------
[HIVE-21952|https://issues.apache.org/jira/browse/HIVE-21952] support UNSET
SERDEPROPERTIES
> ALTER TABLE UNSET SERDEPROPERTIES does not work
> -----------------------------------------------
>
> Key: HIVE-12414
> URL: https://issues.apache.org/jira/browse/HIVE-12414
> Project: Hive
> Issue Type: Bug
> Components: Metastore, SQL
> Affects Versions: 1.1.1
> Reporter: Lenni Kuff
> Assignee: Reuben Kuhnert
> Priority: Major
> Labels: newbie
>
> alter table tablename set tblproperties ('key'='value') => works as expected
> alter table tablename unset tblproperties ('key') => works as expected
> alter table tablename set serdeproperties ('key'='value') => works as
> expected
> alter table tablename unset serdeproperties ('key') => not supported
> FAILED: ParseException line 1:28 mismatched input 'serdeproperties' expecting
> TBLPROPERTIES near 'unset' in alter properties statement
--
This message was sent by Atlassian Jira
(v8.3.4#803005)