[jira] [Commented] (DRILL-3250) Drill fails to compare multi-byte characters from hive table

["Chun Chang (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-3250?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16210351#comment-16210351 ] 

Chun Chang commented on DRILL-3250:
-----------------------------------

0: jdbc:drill:zk=10.10.30.166:5181> select * from t1;
+-------------+
|    name     |
+-------------+
| first name  |
| 老百姓         |
+-------------+

> Drill fails to compare multi-byte characters from hive table
> ------------------------------------------------------------
>
>                 Key: DRILL-3250
>                 URL: https://issues.apache.org/jira/browse/DRILL-3250
>             Project: Apache Drill
>          Issue Type: Sub-task
>          Components: Storage - Hive
>    Affects Versions: 1.1.0
>            Reporter: Krystal
>            Assignee: Vitalii Diravka
>              Labels: ready-to-commit
>             Fix For: 1.11.0
>
>         Attachments: error.log
>
>
> 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



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)