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

Posted to user@impala.apache.org by Sunil Parmar <su...@gmail.com> on 2018/06/15 00:47:42 UTC

Remove comments from the table

We've a table defined in Impala and has some columns of type MAP and STRUCT
i.e. complex type. When accessing the table in HIVE; we get error because
Hive doesn't like some of the comment and interprets table differently.

Is there a way to safely remove comments from Impala table definition ?

Sunil Parmar

Re: Remove comments from the table

Posted by Fredy Wijaya <fw...@cloudera.com>.

You can use "ALTER TABLE <table> SET tblproperties('comment'='')".

In the latest Impala (not released yet), we have new COMMENT ON statements
to add/remove comments: https://issues.apache.org/jira/browse/IMPALA-5614.
COMMENT ON table/view changes were recently merged. To remove the a comment
from a table, you can use "COMMENT ON <table> IS NULL".

>