[HIVE-13983] Unicode insert issue

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.2.0
• Component/s: HiveServer2

Environment

failed in beeline and in odbc

• Assignee: Unassigned
• Reporter: eugene liu
• Created: 09/Jun/16 19:37
• Updated: 09/Jun/16 19:37

Description

Unicode characters in UTF-8 on wire: ¿=C2 BF «=C2 AB é=C3 A9
Characters inserted using INSERT SELECT format stores the values correctly
Characters inserted using INSERT VALUES format stores the values incorrectly. Below was what I did in beeline:

DROP TABLE testch3;
CREATE TABLE testch3(col0 int, col1 CHAR(10), col2 VARCHAR(10), col3 string);
Insert into table testch3 select 1,'¿','«','é' from (select count from testch3) qaz;
Insert into table testch3 values (2,'¿','«','é');
select * from testch3;

------------------------------------------------------+

testch3.col0

testch3.col1

testch3.col2

testch3.col3

------------------------------------------------------+

1	¿	«	é
2	�	�	�

------------------------------------------------------+
2 rows selected (0.251 seconds)