[ 
https://issues.apache.org/jira/browse/HIVE-11837?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Yongzhi Chen updated HIVE-11837:
--------------------------------
    Status: Patch Available  (was: Reopened)

> 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: 1.1.0, 0.13.1
>         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.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.4#6332)

Reply via email to