question Impala and unicode (displaying issue) in Archives of Support Questions (Read Only)

Impala and unicode (displaying issue)

barnoba — Fri, 16 Sep 2022 12:34:10 GMT

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

Re: Impala and unicode (displaying issue)

alex.behm — Tue, 28 Nov 2017 00:41:54 GMT

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?

Re: Impala and unicode (displaying issue)

barnoba — Mon, 04 Dec 2017 10:52:05 GMT

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)

alex.behm — Mon, 04 Dec 2017 17:03:45 GMT

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