wang created HIVE-23771: --------------------------- Summary: load数据到hive,limit 显示用户名中文正确,where 用户名乱码,并且不能使用用户名比对 Key: HIVE-23771 URL: https://issues.apache.org/jira/browse/HIVE-23771 Project: Hive Issue Type: Bug Components: CLI Affects Versions: 2.1.1 Reporter: wang Fix For: 2.1.1 Attachments: image-2020-06-29-15-04-23-999.png, image-2020-06-29-15-08-25-923.png, image-2020-06-29-15-10-10-310.png
建表语句:create table smg_t_usr_inf_23( Usr_ID string, RlgnSvcPltfrmUsr_TpCd string, Rlgn_InsID string, Usr_Nm string ,.... ) ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.MultiDelimitSerDe' WITH SERDEPROPERTIES ("field.delim"="|@|") stored as textfile 导入数据:LOAD DATA LOCAL INPATH '/home/ap/USR_INF 20200622_0001.dat' INTO TABLE usr_inf select * from usr_inf limit 10;显示数据: !image-2020-06-29-15-04-23-999.png! select * from usr_inf where usr_nm = '胡学玲' ;无显示数据: !image-2020-06-29-15-08-25-923.png! 其他select * from usr_inf where usr_id='***';显示数据 !image-2020-06-29-15-10-10-310.png! . 求大神解答,为什么导入的数据是中文但是where就有问题,直接insert into table aa select * from usr_inf;新表 的usr_nm 字段也是同上 ???? -- This message was sent by Atlassian Jira (v8.3.4#803005)