[
https://issues.apache.org/jira/browse/HIVE-12414?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16450272#comment-16450272
]
Anthony Hsu commented on HIVE-12414:
------------------------------------
Currently, the only way to drop SERDEPROPERTIES is to use the Thrift API
directly (e.g.: using the MetaStoreClient via Java code).
> 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
(v7.6.3#76005)
