hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lenni Kuff (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-12182) ALTER TABLE PARTITION COLUMN does not set partition column comments
Date Thu, 15 Oct 2015 04:15:05 GMT
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)

Mime
View raw message