[jira] [Closed] (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:all-tabpanel ]

Chun Chang closed DRILL-3250.
-----------------------------

> 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)