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

2020-06-29 Thread wang (Jira) 


 [ 
https://issues.apache.org/jira/browse/HIVE-23771?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

wang reassigned HIVE-23771:
---

Assignee: wang

> 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
>Assignee: wang
>Priority: Major
> 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)

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

2020-06-29 Thread wang (Jira) 


 [ 
https://issues.apache.org/jira/browse/HIVE-23771?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

wang reassigned HIVE-23771:
---

Assignee: (was: wang)

> 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
>Priority: Major
> 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)