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 Wed, 06 Jul 2016 02:09:11 GMT

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

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

Thanks [~xuefuz] and [~niklaus.xiao] for your inputs.
Besides configuring the underlying DB, I think we also need to change how we create the database
and table in hive's script. This [doc|https://dev.mysql.com/doc/refman/5.7/en/charset-applications.html]
provides a way to set character set per database.

> 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