load data local inpath ‘/home/bgyetl/etl/tmp/new_item_code.csv’ into table test.item_info;
数据乱码:
alter table test.item_info set serdeproperties ('serialization.encoding'= 'GBK');
重新查询数据,中文不乱码了
load data local inpath ‘/home/bgyetl/etl/tmp/new_item_code.csv’ into table test.item_info;
数据乱码:
alter table test.item_info set serdeproperties ('serialization.encoding'= 'GBK');
重新查询数据,中文不乱码了