Lenni Kuff created HIVE-12182:
---------------------------------

             Summary: 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


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)

Reply via email to