[
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)
