[DRILL-4039] Query fails when non-ascii characters are used in string literals

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.1.0
• Fix Version/s: 1.11.0
• Component/s: Client - JDBC
• Labels: ready-to-commit

Environment

Linux lnxx64r6 2.6.32-131.0.15.el6.x86_64 #1 SMP Tue May 10 15:42:40 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux

• Assignee: Unassigned
• Reporter: Sergio Lob
• Reviewer: Sudheesh Katkam
• Created: 05/Nov/15 14:10
• Updated: 07/Nov/18 18:12
• Resolved: 05/May/17 13:32

Description

The following query against DRILL returns this error:

SYSTEM ERROR: CalciteException: Failed to encode 'НАСТРОЕние' in character set 'ISO-8859-1'
cc39118a-cde6-4a6e-a1d6-4b6b7e847b8a on maprd

Query is:

   SELECT
  T1.`F01INT`,
  T1.`F02UCHAR_10`,
  T1.`F03UVARCHAR_10`
   FROM
  DPRV64R6_TRDUNI01T T1
   WHERE
  (T1.`F03UVARCHAR_10` =  'НАСТРОЕние')
   ORDER BY
  T1.`F01INT`;

This issue looks similar to jira HIVE-12207.

Is there a fix or workaround for this?

Issue Links

• incorporates: DRILL-3250 Drill fails to compare multi-byte characters from hive table
• links to: GitHub Pull Request #825

Sub-Tasks

• Drill fails to compare multi-byte characters from hive table: Closed