[ 
https://issues.apache.org/jira/browse/HIVE-12182?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Navis updated HIVE-12182:
-------------------------
    Attachment: HIVE-12182.1.patch.txt

> 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: Navis
>         Attachments: HIVE-12182.1.patch.txt
>
>
> 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)

Reply via email to