Reply
New Contributor
Posts: 5
Registered: ‎07-12-2017
Accepted Solution

Impala and unicode (displaying issue)

[ Edited ]

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

Cloudera Employee
Posts: 290
Registered: ‎10-16-2013

Re: Impala and unicode (displaying issue)

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?

 

New Contributor
Posts: 5
Registered: ‎07-12-2017

Re: Impala and unicode (displaying issue)

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.

Cloudera Employee
Posts: 290
Registered: ‎10-16-2013

Re: Impala and unicode (displaying issue)

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

Announcements