[
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)
