[DRILL-3250] Drill fails to compare multi-byte characters from hive table

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.1.0
• Fix Version/s: 1.11.0
• Component/s: Storage - Hive
• Labels: ready-to-commit
• Assignee: Vitalii Diravka
• Reporter: Krystal
• Reviewer: Chun Chang
• Created: 03/Jun/15 22:58
• Updated: 19/Oct/17 00:06
• Resolved: 22/May/17 14:33

Description

git.commit.id.abbrev=69b39c1

I have a hive table that contains chinese/japanese characters for a varchar column. From hive, the following query run successfully:

select * from voter_hive2 where name='老百姓';

However from sqlline, it fails:
0: jdbc:drill:schema=hive> select * from voter_hive2 where name=_UTF16'老百姓';
Error: PARSE ERROR: From line 1, column 33 to line 1, column 48: Cannot apply = to the two different charsets ISO-8859-1 and UTF-16LE

Issue Links

• is part of: DRILL-4039 Query fails when non-ascii characters are used in string literals
• links to: GitHub Pull Request #841