[ 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)