SQL containing non-ascii characters will fail. in Hue 4.10

#1

I’m using Hue 4.10.（Amazon EMR6.7）
SQL containing non-ascii characters will fail.
It works fine with Hue 4.9.（Amazon EMR6.5）
If I run the SQL in hive it succeeds.
There seems to be a problem with hue 4.10

It happens with the SQL below.

select * from hoge.foo where keyword = 'Á'
select * from hoge.foo where keyword = '日記'

I get the error below.

Error while compiling statement: FAILED: ParseException line 1:93 cannot recognize input near '<EOF>' '<EOF>' '<EOF>' in expression specification

FireShot Capture 075 - Hue - Editor - hue-main.lo.mixi.jp
FireShot Capture 075 - Hue - Editor - hue-main.lo.mixi.jp894×357 14.8 KB

Is there any way to resolve this?

#3

Thank you for your response
I ran the below SQL on demo.gethue.com,

select * from emplist where name = 'Á';

I didn’t get the same error.

#4

Great, then perhaps you can use the latest code from Github instead of the 4.10 release for now? We are planning getting 4.11 out within the next coming weeks.

#5

I’m using Amazon EMR, so I can’t use the latest from github.
If 4.11 fixes this bug, I’d like to wait until 4.11 is released on EMR.