You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "lfh (JIRA)" <ji...@apache.org> on 2015/03/10 15:34:38 UTC
[jira] [Commented] (HIVE-9907) insert into table values() when
UTF-8 character is not correct
[ https://issues.apache.org/jira/browse/HIVE-9907?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14354967#comment-14354967 ]
lfh commented on HIVE-9907:
---------------------------
insert into table test_acid
select 1 , '中文1' , '中文2'
from dual ;
that is ok .
but update ... values ( '中文' ) is not ok
this problem make me crazy .
> insert into table values() when UTF-8 character is not correct
> ----------------------------------------------------------------
>
> Key: HIVE-9907
> URL: https://issues.apache.org/jira/browse/HIVE-9907
> Project: Hive
> Issue Type: Bug
> Components: CLI, Clients, JDBC
> Affects Versions: 0.14.0, 0.13.1, 1.0.0
> Environment: centos 6 LANG=zh_CN.UTF-8
> hadoop 2.6
> hive 1.1.0
> Reporter: lfh
> Priority: Critical
>
> insert into table test_acid partition(pt='pt_2')
> values( 2, '中文_2' , 'city_2' )
> ;
> hive> select *
> > from test_acid
> > ;
> OK
> 2 -�_2 city_2 pt_2
> Time taken: 0.237 seconds, Fetched: 1 row(s)
> hive>
> CREATE TABLE test_acid(id INT,
> name STRING,
> city STRING)
> PARTITIONED BY (pt STRING)
> clustered by (id) into 1 buckets
> stored as ORCFILE
> TBLPROPERTIES('transactional'='true')
> ;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)