Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Impala and unicode (displaying issue)

Solved Go to solution

Impala and unicode (displaying issue)

Explorer

Hi, all!

I'am using impyla(python labrary) to insert data to Impala and all the strings are in unicode format.

All the tables have STRING format of the fields.

But i can't see unicode symbols using select statement from client(using jdbc or odbc driver).

How can I handle it?

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Impala and unicode (displaying issue)

Explorer

I've read everything related to data types in Impala

But finally, I found out that the problem was in SQL query constructing on Python side.

3 REPLIES 3

Re: Impala and unicode (displaying issue)

Master Collaborator

Impala does not fully support Unicode. See "Character Sets" here:

https://www.cloudera.com/documentation/enterprise/latest/topics/impala_string.html

 

That said, reading/writing UTF-8 should work in most circumstances. Is your data in UTF-8 or a different representation of Unicode? Other encodings will likely not work at all.

 

Do queries using the Impala Shell return expected results?

 

Highlighted

Re: Impala and unicode (displaying issue)

Explorer

I've read everything related to data types in Impala

But finally, I found out that the problem was in SQL query constructing on Python side.

Re: Impala and unicode (displaying issue)

Master Collaborator

Thanks for following up! Do you mind summarizing the changes you made to fix it so others can benefit from your solution?