Support Questions
Find answers, ask questions, and share your expertise

Problem with encoding/decoding in Hue in CDP 7.1.1

Problem with encoding/decoding in Hue in CDP 7.1.1

New Contributor

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)"

 

Screenshot 2020-07-15 at 14.04.17.png

 

 

 

 

 

 

 

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

 

Screenshot 2020-07-15 at 14.03.41.png

 

 

 

 

 

 

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 REPLIES 2
Highlighted

Re: Problem with encoding/decoding in Hue in CDP 7.1.1

Master Collaborator

@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;

 


Cheers!
Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.
Highlighted

Re: Problem with encoding/decoding in Hue in CDP 7.1.1

New Contributor

Hi @nikolayburiak 

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

Thanks!

Don't have an account?