You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Sergey Shelukhin (JIRA)" <ji...@apache.org> on 2015/09/16 20:37:45 UTC
[jira] [Resolved] (HIVE-11837) comments do not support Chinese
characters well.
[ https://issues.apache.org/jira/browse/HIVE-11837?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sergey Shelukhin resolved HIVE-11837.
-------------------------------------
Resolution: Duplicate
> comments do not support Chinese 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
> Priority: Minor
>
> 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)