You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "liugaopeng (JIRA)" <ji...@apache.org> on 2017/07/06 03:31:00 UTC
[jira] [Updated] (HIVE-17049) hive doesn't support chinese comments
for columns
[ https://issues.apache.org/jira/browse/HIVE-17049?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
liugaopeng updated HIVE-17049:
------------------------------
Description:
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.....
was:
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 guidence.....
> 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)