You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Rudd Chen (JIRA)" <ji...@apache.org> on 2015/09/16 08:27:45 UTC
[jira] [Created] (HIVE-11837) comments do not support Chinese
characters well.
Rudd Chen created HIVE-11837:
--------------------------------
Summary: 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: 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
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)