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