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

Reply via email to