[HIVE-9907] insert into table values() when UTF-8 character is not correct

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: 0.13.1, 0.14.0, 1.0.0
• Component/s: CLI, Clients, JDBC

Environment

centos 6 LANG=zh_CN.UTF-8
hadoop 2.6
hive 1.1.0

• Assignee: Niklaus Xiao
• Reporter: Fanhong Li
• Created: 10/Mar/15 11:43
• Updated: 02/Feb/16 15:39

Description

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