You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Anthony Hsu (JIRA)" <ji...@apache.org> on 2018/04/24 17:39:00 UTC

[jira] [Commented] (HIVE-12414) ALTER TABLE UNSET SERDEPROPERTIES does not work

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