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.

Loading Multi Byte Data in hive table

Loading Multi Byte Data in hive table

Explorer

I am trying to load the hive table with multi byte data.The data consists of Chinese characters in it. When i am loading the data i see no issue. But when i am trying to read the data the Chinese characters are not properly shown. Is there is any way i can solve this.

1 REPLY 1
Highlighted

Re: Loading Multi Byte Data in hive table

Hive supports UTF-8. Make sure your text files are in UTF-8. Example:

hive> select * from cities where locate('京',city)>0;
東京
北京

hive> describe cities;
city                	string
Don't have an account?
Coming from Hortonworks? Activate your account here