[
https://issues.apache.org/jira/browse/HIVE-14156?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15362286#comment-15362286
]
Bing Li commented on HIVE-14156:
--------------------------------
Hi, [~xiaobingo]
I noticed that you fixed HIVE-8550 on windows, and mentioned that it should
work on Linux.
I ran the similar query but failed with MySQL.
In order to make it work, besides the changes in Hive schema script, I also
need to update MySQL's configuration file which is my.cnf.
When you ran it on windows, did you change the configuraions for the database?
Did you have a chance to run it on Linux as well?
Thank you.
> 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)
