[
https://issues.apache.org/jira/browse/HIVE-3456?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13464285#comment-13464285
]
Richard Nadeau commented on HIVE-3456:
--------------------------------------
Looks like this works:
ALTER TABLE test_table SET TBLPROPERTIES ('comment'='This is a test table.');
Documentation:
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-AlterTableProperties
Oddly though, Hive will lowercase the table comment at table creation time, but
"COMMENT" and "comment" are handled as two different property names when using
SET TBLPROPERTIES, so you could end up with this:
parameters:{last_modified_by=joe, last_modified_time=1348701745, COMMENT=This
is apparently the *wrong* comment., transient_lastDdlTime=1348701745,
comment=This is apparently the *right* comment.}
> No apparent way to change table-level COMMENT data
> --------------------------------------------------
>
> Key: HIVE-3456
> URL: https://issues.apache.org/jira/browse/HIVE-3456
> Project: Hive
> Issue Type: Bug
> Components: Documentation, Metastore
> Affects Versions: 0.7.0, 0.7.1, 0.8.0, 0.8.1, 0.9.0
> Reporter: Ryan Harris
> Priority: Minor
>
> Not sure if this is a documentation issue, or a feature that is lacking from
> ALTER TABLE...
> Setting a COMMENT on a table during initial creation is straightforward.
> Changing column names and column comments is also straightforward using ALTER
> TABLE CHANGE...
> However, I have found no way, other than manually editing the metadata to
> set/change the table-level comment for a table after it has been created.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
