Problem with encoding/decoding in Hue in CDP 7.1.1

[#1]

Hi!

I try to run the SQL query to Hive in Hue Hive Editor, but get an error - "'ascii' codec can't decode byte 0xd0 in position 8: ordinal not in range(128)"

If I run the same SQL query in Hive CLI it's working.

This problem is in CDP 7.1.1.

Could someone help me?

P.S. Also, I have run the same SQL query in CDH 6.3.3 and it's working correctly.

P.P.S. I found ticket in Jira with the same issue, and it was was in 2016 - https://issues.cloudera.org/browse/HUE-3803

[#2]

@nikolayburiak This may be due to encoding issue on HMS database. Can you try to change the format something like 

alter table COLUMNS_V2 modify column COMMENT varchar(256) character set utf8;

[#3]

Hi @nikolayburiak 

could you please confirm that the proposed solution works or not?

Thanks!