hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rui Li (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-14156) Problem with Chinese characters as partition value when using MySQL
Date Thu, 07 Jul 2016 02:17:10 GMT

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

Rui Li commented on HIVE-14156:
-------------------------------

[~Ferd] - my understanding is that when Hive creates database and tables, it specifies the
character set to be used. So just configuring MySQL won't work. [~libing], please help verify
this.
One concern is I'm not sure if this will bring any compatibility issue for users using an
early version of MySQL. Besides, does anybody know if we even allow users to use unicode as
partition value?

> 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)

Mime
View raw message