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
Post a Comment