You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "niklaus xiao (JIRA)" <ji...@apache.org> on 2016/07/05 12:53:11 UTC
[jira] [Comment Edited] (HIVE-14156) Problem with Chinese
characters as partition value when using MySQL
[ https://issues.apache.org/jira/browse/HIVE-14156?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15362443#comment-15362443 ]
niklaus xiao edited comment on HIVE-14156 at 7/5/16 12:53 PM:
--------------------------------------------------------------
I tried this on postgres, seems not an issue.
{code}
create table foo (name string, age int) partitioned by (city string) row format delimited fields terminated by ',';
alter table foo add partition(city='深圳');
show partitions foo;
+------------+--+
| partition |
+------------+--+
| city=深圳 |
+------------+--+
1 row selected (0.355 seconds)
{code}
was (Author: niklaus.xiao):
I tried this on postgres, seems not an issue.
{quote}
create table foo (name string, age int) partitioned by (city string) row format delimited fields terminated by ',';
alter table foo add partition(city='深圳');
show partitions foo;
+------------+--+
| partition |
+------------+--+
| city=深圳 |
+------------+--+
1 row selected (0.355 seconds)
{quote}
> 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)