hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "darkz (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-11837) comments do not support unicode characters well.
Date Tue, 07 Mar 2017 07:01:32 GMT

    [ https://issues.apache.org/jira/browse/HIVE-11837?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15898852#comment-15898852
] 

darkz commented on HIVE-11837:
------------------------------

Why this path not merge into the hive code so long

> comments do not support unicode characters well.
> ------------------------------------------------
>
>                 Key: HIVE-11837
>                 URL: https://issues.apache.org/jira/browse/HIVE-11837
>             Project: Hive
>          Issue Type: Bug
>          Components: Hive
>    Affects Versions: 0.13.1, 1.1.0
>         Environment: Hadoop 2.7
> Hive 0.13.1 / Hive 1.1.0
> RHEL 6.4 / SLES 11.3
>            Reporter: Rudd Chen
>            Assignee: Rudd Chen
>            Priority: Minor
>         Attachments: HIVE-11837.1.patch, HIVE-11837.patch
>
>
> the terminal encoding is set to UTF-8, It can display Chinese characters. 
> then I create a table with a comment in Chinese, both "show create table" and "desc formatted
table" can not display the Chinese characters in the table comments, meanwhile it can display
Chinese characters in column comment.. See below:
> 0: jdbc:hive2://ha-cluster/default> create table tt(id int comment '列中文测试')
comment '表中文测试';
> No rows affected (0.152 seconds)
> 0: jdbc:hive2://ha-cluster/default> 
> 0: jdbc:hive2://ha-cluster/default> 
> 0: jdbc:hive2://ha-cluster/default> desc formatted tt;   
> +-------------------------------+-------------------------------------------------------+---------------------------------+
> |           col_name            |                       data_type                   
   |             comment             |
> +-------------------------------+-------------------------------------------------------+---------------------------------+
> | # col_name                    | data_type                                         
   | comment                         |
> |                               | NULL                                              
   | NULL                            |
> | id                            | int                                               
   | 列中文测试                           |
> |                               | NULL                                              
   | NULL                            |
> | # Detailed Table Information  | NULL                                              
   | NULL                            |
> | Database:                     | default                                           
   | NULL                            |
> | Owner:                        | admin                                             
   | NULL                            |
> | CreateTime:                   | Wed Sep 16 11:13:34 CST 2015                      
   | NULL                            |
> | LastAccessTime:               | UNKNOWN                                           
   | NULL                            |
> | Protect Mode:                 | None                                              
   | NULL                            |
> | Retention:                    | 0                                                 
   | NULL                            |
> | Location:                     | hdfs://hacluster/user/hive/warehouse/tt           
   | NULL                            |
> | Table Type:                   | MANAGED_TABLE                                     
   | NULL                            |
> | Table Parameters:             | NULL                                              
   | NULL                            |
> |                               | comment                                           
   | \u8868\u4E2D\u6587\u6D4B\u8BD5  |
> |                               | transient_lastDdlTime                             
   | 1442373214                      |
> |                               | NULL                                              
   | NULL                            |
> | # Storage Information         | NULL                                              
   | NULL                            |
> | SerDe Library:                | org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
 | NULL                            |
> | InputFormat:                  | org.apache.hadoop.hive.ql.io.RCFileInputFormat    
   | NULL                            |
> | OutputFormat:                 | org.apache.hadoop.hive.ql.io.RCFileOutputFormat   
   | NULL                            |
> | Compressed:                   | No                                                
   | NULL                            |
> | Num Buckets:                  | -1                                                
   | NULL                            |
> | Bucket Columns:               | []                                                
   | NULL                            |
> | Sort Columns:                 | []                                                
   | NULL                            |
> | Storage Desc Params:          | NULL                                              
   | NULL                            |
> |                               | serialization.format                              
   | 1                               |
> +-------------------------------+-------------------------------------------------------+---------------------------------+
> 27 rows selected (0.172 seconds)
> 0: jdbc:hive2://ha-cluster/default> show create table tt;
> +------------------------------------------------------------+
> |                       createtab_stmt                       |
> +------------------------------------------------------------+
> | CREATE  TABLE `tt`(                                        |
> |   `id` int COMMENT '-�K�')                                |
> | COMMENT 'h-�K�'                                            |
> | ROW FORMAT SERDE                                           |
> |   'org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe'   |
> | STORED AS INPUTFORMAT                                      |
> |   'org.apache.hadoop.hive.ql.io.RCFileInputFormat'         |
> | OUTPUTFORMAT                                               |
> |   'org.apache.hadoop.hive.ql.io.RCFileOutputFormat'        |
> | LOCATION                                                   |
> |   'hdfs://hacluster/user/hive/warehouse/tt'                |
> | TBLPROPERTIES (                                            |
> |   'transient_lastDdlTime'='1442373214')                    |
> +------------------------------------------------------------+
> 13 rows selected (0.129 seconds)
> 0: jdbc:hive2://ha-cluster/default> 



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message