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/06 22:37:11 UTC

[jira] [Updated] (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:all-tabpanel ]

Naveen Gangam updated HIVE-12182:
---------------------------------
    Attachment: HIVE-12182.2.patch

Incorporating feedback from the review.
  1) Modified existing qtest to cover this.
  2) Unescaped the string literal for comment value.

> 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.2.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)