[ 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.patch Patch attached to the jira. I have considered merging this syntax with the syntax for renaming / changing non-partition column definitions ALTER TABLE <tableName> CHANGE COLUMN <oldCOL> <newCOL> COMMENT '<comment>'; So for a regular column (non-partitioned column) changing the comment would be alter table part_test change column foo foo string COMMENT 'newcomment'; The above syntax doesnt work for the partitioned columns. There is a good reason. The change column syntax provides the ability to rename partition columns and also re-order them. Renaming and re-ordering paritition columns IS NOT possible because the directory paths on HDFS will have to re-structured. So its best we address this bug within its context. > 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)