drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From WeiWan <wei...@sunteng.com>
Subject Re: a drill question
Date Tue, 03 Jan 2017 15:44:40 GMT
'ISO-8859-1’ character set does not support Chinese characters. Put -Dsaffron.default.charset=UTF-16LE
to your DRILL_JAVA_OPTS, i.e. 
export DRILL_JAVA_OPTS="-Dsaffron.default.charset=UTF-16LE ... "
in drill-env.sh.

And after you change the character set setting, another exception may throw, check this issue:
https://issues.apache.org/jira/browse/DRILL-4039 <https://issues.apache.org/jira/browse/DRILL-4039>

You will need to fix it following patch in the issue. 

Flow Wei

> On Jan 3, 2017, at 14:58, roller <2916199721@qq.com> wrote:
> hello ,i have a drill `s question.when i excute this sql "select  ID  , Code , id as
newId, case  when Code='auth' then '男' else 'ttt' end as newCode from ( select ID,Name,Code
from mysql.auth_center.admin_menu where 1=1 ) as sqlInput
> ", it produce a exception,ths erro info is "org.apache.drill.common.exceptions.UserRemoteException:
SYSTEM ERROR: CalciteException: Failed to encode '男' in character set 'ISO-8859-1' [Error
Id: 8fdafdae-8368-45e3-a580-65a3b8213a98 on DESKTOP-P161MQ6:31010]";
>   now,i how to solvet this.thake you for help;

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message