[
https://issues.apache.org/jira/browse/HIVE-12182?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14988071#comment-14988071
]
Yongzhi Chen commented on HIVE-12182:
-------------------------------------
I think it is useful to handle the special charactors which need escape, for
example:
{noformat}
create table tf (val int comment 'it\'s a dog');
describe tf;
+-----------+------------+-------------+--+
| col_name | data_type | comment |
+-----------+------------+-------------+--+
| val | int | it's a dog |
+-----------+------------+-------------+--+
{noformat}
> 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)
