hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "liugaopeng (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-17049) hive doesn't support chinese comments for columns
Date Thu, 06 Jul 2017 06:49:00 GMT

    [ https://issues.apache.org/jira/browse/HIVE-17049?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16076032#comment-16076032
] 

liugaopeng commented on HIVE-17049:
-----------------------------------

[~linzhangbing]  I tried to change the charset of COMMENT field, then create the table with
Chinese comments. But it doesn't work, all Chinese still display as question mark.....:(

> hive doesn't support chinese comments for columns
> -------------------------------------------------
>
>                 Key: HIVE-17049
>                 URL: https://issues.apache.org/jira/browse/HIVE-17049
>             Project: Hive
>          Issue Type: Bug
>          Components: CLI
>    Affects Versions: 1.2.1
>         Environment: hive 1.2.1 in HDP 
>            Reporter: liugaopeng
>
> 1.  alter table stg.test_chinese change chinesetitle chinesetitle tinyint comment '中文';
> 2.  desc stg.test_chinese;
> Result: chinese comment "中文" becase "??"
> also, if i modify the comment via hive view, it will still display the messy code "??".
> I did some testing, but cannot fix it, such as:
> 1. change the hive.COLUMNS_V2 to UTF-8 chartset.
> 2. append the characterEncoding=UTF-8 to hive_to_mysqlmetadata url 
> i found some ideas that need to apply some patch to fix it, but seems they all effects
in 0.x version, i use the 1.2.1 version.
> Please give some guidance.....



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message