Return-Path: X-Original-To: apmail-hive-issues-archive@minotaur.apache.org Delivered-To: apmail-hive-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 61D8718244 for ; Tue, 16 Feb 2016 10:31:18 +0000 (UTC) Received: (qmail 42076 invoked by uid 500); 16 Feb 2016 10:31:18 -0000 Delivered-To: apmail-hive-issues-archive@hive.apache.org Received: (qmail 42052 invoked by uid 500); 16 Feb 2016 10:31:18 -0000 Mailing-List: contact issues-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list issues@hive.apache.org Received: (qmail 42035 invoked by uid 99); 16 Feb 2016 10:31:18 -0000 Received: from arcas.apache.org (HELO arcas) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 16 Feb 2016 10:31:18 +0000 Received: from arcas.apache.org (localhost [127.0.0.1]) by arcas (Postfix) with ESMTP id 1F0EB2C1F5B for ; Tue, 16 Feb 2016 10:31:18 +0000 (UTC) Date: Tue, 16 Feb 2016 10:31:18 +0000 (UTC) From: "zengzhaozheng (JIRA)" To: issues@hive.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (HIVE-11837) comments do not support unicode characters well. MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/HIVE-11837?page=3Dcom.atlassia= n.jira.plugin.system.issuetabpanels:all-tabpanel ] zengzhaozheng updated HIVE-11837: --------------------------------- Assignee: (was: zengzhaozheng) > 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 > Priority: Minor > Attachments: HIVE-11837.patch > > > the terminal encoding is set to UTF-8, It can display Chinese characters.= =20 > 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 t= able comments, meanwhile it can display Chinese characters in column commen= t.. See below: > 0: jdbc:hive2://ha-cluster/default> create table tt(id int comment '=E5= =88=97=E4=B8=AD=E6=96=87=E6=B5=8B=E8=AF=95') comment '=E8=A1=A8=E4=B8=AD=E6= =96=87=E6=B5=8B=E8=AF=95'; > No rows affected (0.152 seconds) > 0: jdbc:hive2://ha-cluster/default>=20 > 0: jdbc:hive2://ha-cluster/default>=20 > 0: jdbc:hive2://ha-cluster/default> desc formatted tt; =20 > +-------------------------------+----------------------------------------= ---------------+---------------------------------+ > | col_name | data_type = | comment | > +-------------------------------+----------------------------------------= ---------------+---------------------------------+ > | # col_name | data_type = | comment | > | | NULL = | NULL | > | id | int = | =E5=88=97=E4=B8=AD=E6=96=87=E6=B5=8B=E8=AF=95 = | > | | 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.RCFileInpu= tFormat | NULL | > | OutputFormat: | org.apache.hadoop.hive.ql.io.RCFileOutp= utFormat | 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 '=17-=EF=BF=BDK=EF=BF=BD') = | > | COMMENT 'h-=EF=BF=BDK=EF=BF=BD' = | > | 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'=3D'1442373214') | > +------------------------------------------------------------+ > 13 rows selected (0.129 seconds) > 0: jdbc:hive2://ha-cluster/default>=20 -- This message was sent by Atlassian JIRA (v6.3.4#6332)