[HIVE-23771] load数据到hive,limit 显示用户名中文正确,where 用户名乱码,并且不能使用用户名比对

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.1.1
• Component/s: CLI
• Target Version/s: 2.1.1
• Assignee: Unassigned
• Reporter: wang
• Due: 29/Jun/20
• Created: 29/Jun/20 07:12
• Updated: 11/Sep/20 07:10

Description

建表语句: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;显示数据:

 

select * from usr_inf where usr_nm = '胡学玲' ;无显示数据:

 

其他select * from usr_inf where usr_id='***';显示数据 .

求大神解答,为什么导入的数据是中文但是where就有问题,直接insert into table aa select * from usr_inf;新表 的usr_nm 字段也是同上 ????