[
https://issues.apache.org/jira/browse/DRILL-4039?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14992194#comment-14992194
]
Sergio Lob commented on DRILL-4039:
-----------------------------------
Hi Julian,
I tried a couple of your suggestions:
1. (T1.`F03UVARCHAR_10` = n'НАСТРОЕние')
returned the same error
2. (T1.`F03UVARCHAR_10` = _UTF16'НАСТРОЕние')
returned this error:
VALIDATION ERROR: From line 1, column 93 to line 1, column 133: Cannot apply =
to the two different charsets ISO-8859-1 and UTF-16LE
By the way, I am using java JDBC program to make the request.
> Query fails when non-ascii characters are used in string literals
> -----------------------------------------------------------------
>
> Key: DRILL-4039
> URL: https://issues.apache.org/jira/browse/DRILL-4039
> Project: Apache Drill
> Issue Type: Bug
> Components: Client - JDBC
> Affects Versions: 1.1.0
> 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
> Reporter: Sergio Lob
>
> 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?
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
