hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yongzhi Chen (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-12182) ALTER TABLE PARTITION COLUMN does not set partition column comments
Date Tue, 01 Dec 2015 15:45:11 GMT

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

Yongzhi Chen updated HIVE-12182:
--------------------------------
    Attachment: HIVE-12182-branch1.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: Naveen Gangam
>         Attachments: HIVE-12182-branch1.txt, HIVE-12182.2.patch, HIVE-12182.3.patch,
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)

Mime
View raw message