[
https://issues.apache.org/jira/browse/HIVE-14156?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15362677#comment-15362677
]
Xuefu Zhang commented on HIVE-14156:
------------------------------------
Since the partition names are stored in underlying metadata store DB, that DB
has to support unicode in order to support unicode partition names. This in
return might require some configuration changes (to enable unicode values) on
the DB.
Here is the doc for mysql:
http://dev.mysql.com/doc/refman/5.7/en/charset-unicode.html
> Problem with Chinese characters as partition value when using MySQL
> -------------------------------------------------------------------
>
> Key: HIVE-14156
> URL: https://issues.apache.org/jira/browse/HIVE-14156
> Project: Hive
> Issue Type: Bug
> Components: Metastore
> Affects Versions: 1.2.1, 2.0.0
> Reporter: Bing Li
> Assignee: Bing Li
>
> Steps to reproduce:
> create table t1 (name string, age int) partitioned by (city string) row
> format delimited fields terminated by ',';
> load data local inpath '/tmp/chn-partition.txt' overwrite into table t1
> partition (city='北京');
> The content of /tmp/chn-partition.txt:
> 小明,20
> 小红,15
> 张三,36
> 李四,50
> When check the partition value in MySQL, it shows ?? instead of "北京".
> When run "drop table t1", it will hang.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
