[
https://issues.apache.org/jira/browse/DRILL-4039?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15151866#comment-15151866
]
Jingguo Yao commented on DRILL-4039:
------------------------------------
The proposed change will affect {{show tables}} and {{describe}}. The following
show the problem of {{show tables}}.
{quote}
0: jdbc:drill:zk=local> use hive;
+-------+-----------------------------------+
| ok | summary |
+-------+-----------------------------------+
| true | Default schema changed to [hive] |
+-------+-----------------------------------+
1 row selected (0.872 seconds)
0: jdbc:drill:zk=local> show tables;
Feb 18, 2016 3:21:21 PM org.apache.calcite.sql.validate.SqlValidatorException
<init>
SEVERE: org.apache.calcite.sql.validate.SqlValidatorException: Cannot apply =
to the two different charsets UTF-16LE and ISO-8859-1
Feb 18, 2016 3:21:21 PM org.apache.calcite.runtime.CalciteException <init>
SEVERE: org.apache.calcite.runtime.CalciteContextException: At line 0, column
0: Cannot apply = to the two different charsets UTF-16LE and ISO-8859-1
Error: VALIDATION ERROR: At line 0, column 0: Cannot apply = to the two
different charsets UTF-16LE and ISO-8859-1
[Error Id: 23a56a6c-7d6d-497f-ac82-7c415937378e on jinglin:31010]
(state=,code=0)
{quote}
The following text shows the problem of {{describe}}:
{quote}
0: jdbc:drill:zk=local> describe adminlog;
Feb 18, 2016 3:29:15 PM org.apache.calcite.sql.validate.SqlValidatorException
<init>
SEVERE: org.apache.calcite.sql.validate.SqlValidatorException: Cannot apply =
to the two different charsets UTF-16LE and ISO-8859-1
Feb 18, 2016 3:29:15 PM org.apache.calcite.runtime.CalciteException <init>
SEVERE: org.apache.calcite.runtime.CalciteContextException: At line 0, column
0: Cannot apply = to the two different charsets UTF-16LE and ISO-8859-1
Error: VALIDATION ERROR: At line 0, column 0: Cannot apply = to the two
different charsets UTF-16LE and ISO-8859-1
[Error Id: db0a3169-9a1d-4d64-8242-f0f35e24c07c on jinglin:31010]
(state=,code=0)
0: jdbc:drill:zk=local>
{quote}
> 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)
