[
https://issues.apache.org/jira/browse/HIVE-14156?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Bing Li updated HIVE-14156:
---------------------------
Comment: was deleted
(was: Hi, Rui
I didn't have a chance to try other databases, like Derby, Oracle and Postgres.
But one thing I found is that in the scripts for other databases, it didn't
specify the character set.
)
> 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)
