drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chun Chang (JIRA)" <j...@apache.org>
Subject [jira] [Closed] (DRILL-3250) Drill fails to compare multi-byte characters from hive table
Date Thu, 19 Oct 2017 00:07:00 GMT

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

Mime
View raw message