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.
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