execl保存为以逗号分隔的csv文件加载到hive表,查询时会出现中文乱码,可以建表时指定编码格式
CREATE TABLE code(
prod_spec_code string,
prod_spec_name string,
num string
)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
WITH SERDEPROPERTIES("field.delim"=',',"serialization.encoding"='GBK')
STORED AS TEXTFILE;