Can't execute hive sql include chinese

[gzqcason]

Dear all
as you can see the statement can't includ Chinese，

I checked the metadata in MySQL, the Chinese parsed into unicode and kept at table ‘desktop_docyment2’

and then I use unicode directly, Hue execute good. I don't know how to solve this problem, need help, thanks a lot.

btw, I use open source hue-4.10 version and hive-2.7. I changed encoding in hue's metatable(make chinese can show on web), and changed python default encoding into utf-8. However I guess it's only something woring in parse-execute stage.

[Akhilsnaik]

do you know what is there in the logs ?

probably hitting : #1903 ?

[gzqcason]

As i rerstart Hue like ‘nohup supervisor > test.log 2>&1 &’ , got same error info in 'hue/logs/error.log' while execute sql :
thrift_util and decorators: QueryError: Error while compiling statement: FAILED: ParseException line 1:9 cannot recognize input near '' '' '' in select clause

run the test shell got info below:

met similar problem befor I changed python2.7's default encoding (from ascii to utf8) ：
‘Processing exception: 'ascii' codec can't encode characters in position 68-69: ordinal not in range(128)’

[2416210017]

Have you solved it? I also report the same error here. Hue version 4.10

[2416210017]

vim /data/hue-4.10/hue/apps/beeswax/gen-py/TCLIService/ttypes.py

oprot.writeString(self.statement) 编辑为 oprot.writeString(self.statement.encode('utf-8'))

Here is the answer:
#2606

[Harshg999]

vim /data/hue-4.10/hue/apps/beeswax/gen-py/TCLIService/ttypes.py

oprot.writeString(self.statement) 编辑为 oprot.writeString(self.statement.encode('utf-8'))

Here is the answer: #2606

The fix is now also part of the latest 4.11.0 release.
For earlier versions, fix can be applied as described in: #2606

Thanks @2416210017 for pointing out!