[HIVE-11721] non-ascii characters shows improper with "insert into"

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.1.0, 1.2.1, 2.0.0
• Fix Version/s: 2.0.0
• Component/s: Database/Schema
• Assignee: Aleksei Statkevich
• Reporter: Jun Yin
• Created: 02/Sep/15 20:37
• Updated: 16/Feb/16 23:50
• Resolved: 05/Nov/15 22:03

Description

Hive: 1.1.0

hive> create table char_255_noascii as select cast("Garçu 谢谢 Kôkaku ありがとうございますkidôtai한국어" as char(255));
hive> select * from char_255_noascii;
OK
Garçu 谢谢 Kôkaku ありがとうございますkidôtai>한국어

it shows correct, and also it works good with "LOAD DATA"
but when I try another way to insert data as below:

hive> create table nonascii(t1 char(255));
OK
Time taken: 0.125 seconds
hive> insert into nonascii values("Garçu 谢谢 Kôkaku ありがとうございますkidôtai한국어");
hive> select * from nonascii;
OK
Gar�u "" K�kaku B�LhFTVD~Ykid�tai\m�