You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@drill.apache.org by roller <29...@qq.com> on 2017/01/03 06:58:06 UTC

a drill question

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;

Re: a drill question

Posted by WeiWan <we...@sunteng.com>.

'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. 

Regards
Flow Wei

> On Jan 3, 2017, at 14:58, roller <29...@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;