hadoop - HIVE create external table with unicode, shows mess codes -


i'm creating hive external table text file, contains unicode. after created it, when querying data, mess codes shown.

this text file

0,阿会喃 1,韦昭 2,伊籍 3,尹赏 5,尹默 6,于禁 7,于诠 8,卫瓘 9,袁遗 10,袁胤 

after added hdfs, can show content using fs -cat, shown correctly.

but after created hive external table use hql

create external table san11.wujiang2(index int, name string) row format delimited fields terminated ',' location '/san11/tables/wujiang2'; 

and query hql

select * san11.wujiang2; 

mess codes shows , indices null

null     ?�o�u null    null null     �-f null    null null      null    null null    null null     9\o� null    null null     9\؞ 

anyone can help? thanks


Comments

Popular posts from this blog

java - Date formats difference between yyyy-MM-dd'T'HH:mm:ss and yyyy-MM-dd'T'HH:mm:ssXXX -

c# - Get rid of xmlns attribute when adding node to existing xml -