You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Naveen Gangam (JIRA)" <ji...@apache.org> on 2015/11/02 23:24:27 UTC

[jira] [Commented] (HIVE-12182) ALTER TABLE PARTITION COLUMN does not set partition column comments

    [ https://issues.apache.org/jira/browse/HIVE-12182?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14986169#comment-14986169 ] 

Naveen Gangam commented on HIVE-12182:
--------------------------------------

The test failures do not appear to be related to the patch. Proposed fix is posted to RB at https://reviews.apache.org/r/39881/

> ALTER TABLE PARTITION COLUMN does not set partition column comments
> -------------------------------------------------------------------
>
>                 Key: HIVE-12182
>                 URL: https://issues.apache.org/jira/browse/HIVE-12182
>             Project: Hive
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 1.2.1
>            Reporter: Lenni Kuff
>            Assignee: Naveen Gangam
>         Attachments: HIVE-12182.patch
>
>
> ALTER TABLE PARTITION COLUMN does not set partition column comments. The syntax is accepted, but the COMMENT for the column is ignored.
> {code}
> 0: jdbc:hive2://localhost:10000/default> create table part_test(i int comment 'HELLO') partitioned by (j int comment 'WORLD');
> No rows affected (0.104 seconds)
> 0: jdbc:hive2://localhost:10000/default> describe part_test;
> +--------------------------+-----------------------+-----------------------+--+
> |         col_name         |       data_type       |        comment        |
> +--------------------------+-----------------------+-----------------------+--+
> | i                        | int                   | HELLO                 |
> | j                        | int                   | WORLD                 |
> |                          | NULL                  | NULL                  |
> | # Partition Information  | NULL                  | NULL                  |
> | # col_name               | data_type             | comment               |
> |                          | NULL                  | NULL                  |
> | j                        | int                   | WORLD                 |
> +--------------------------+-----------------------+-----------------------+--+
> 7 rows selected (0.109 seconds)
> 0: jdbc:hive2://localhost:10000/default> alter table part_test partition column (j int comment 'WIDE');
> No rows affected (0.121 seconds)
> 0: jdbc:hive2://localhost:10000/default> describe part_test;
> +--------------------------+-----------------------+-----------------------+--+
> |         col_name         |       data_type       |        comment        |
> +--------------------------+-----------------------+-----------------------+--+
> | i                        | int                   | HELLO                 |
> | j                        | int                   |                       |
> |                          | NULL                  | NULL                  |
> | # Partition Information  | NULL                  | NULL                  |
> | # col_name               | data_type             | comment               |
> |                          | NULL                  | NULL                  |
> | j                        | int                   |                       |
> +--------------------------+-----------------------+-----------------------+--+
> 7 rows selected (0.108 seconds)
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)