hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Richard Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-3456) No apparent way to change table-level COMMENT data
Date Wed, 26 Sep 2012 23:31:07 GMT

    [ 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

Mime
View raw message