[
https://issues.apache.org/jira/browse/HIVE-12182?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14987831#comment-14987831
]
Yongzhi Chen commented on HIVE-12182:
-------------------------------------
Following is from BaseSemanticAnalyzer.java
Should this patch do the similar(use unescapeSQLString ...)?
// child 2 is the optional comment of the column
if (child.getChildCount() == 3) {
col.setComment(unescapeSQLString(child.getChild(2).getText()));
}
> 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)
