[GitHub] [doris] icedrugs89 opened a new issue, #11888: [Bug] 数据列内容不一致

[GitBox]

icedrugs89 opened a new issue, #11888:
URL: https://github.com/apache/doris/issues/11888

   ### Search before asking
   
   - [X] I had searched in the 
[issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and 
found no similar issues.
   
   
   ### Version
   
   1.1.1-rc03-2dbd70b
   
   ### What's Wrong?
   
   dwd_trade_draw_pdi表更新模型，主键字段为loan_req_no，数据量9亿行
   1、执行如下sql，返回100条数据(loan_no字段实际为空的，出现很多都为固定的一个值346228xxx79522)：
   select * from fin_dw.dwd_trade_draw_pdi a where date(a.time_loan) 
>='2022-01-01' and a.loan_state = 'ARJ' and a.loan_no >'0' and a.loan_no not 
in('NULL','null','') limit 100;
   返回数据为如下：
   
![image](https://user-images.githubusercontent.com/100941547/185307612-c1be71fb-cf9f-4e50-a5f4-4e616b57dfc6.png)
   2、使用第一条数据的loan_req_no=LP622990xxxx8176进行查询,返回数据中loan_no字段为空
   select * from fin_dw.dwd_trade_draw_pdi a where  
loan_req_no='LP622990xxxx8176'
   
![image](https://user-images.githubusercontent.com/100941547/185307630-b5180003-b630-466f-bc87-c388208f9e1c.png)
   3、使用loan_no被替换的值346228xxx79522条件查询，整张表只有一行匹配的值
   select * from fin_dw.dwd_trade_draw_pdi a where  loan_no='346228xxx79522'
   
4、hive使用第一条数据的loan_req_no=LP622990xxxx8176进行查询,返回数据中loan_no字段为空，其他字段值相同(与第二步一致)
   select * from fin_dw.dwd_trade_draw_pdi a where  
loan_req_no='LP622990xxxx8176'
   
   
   
   ### What You Expected?
   
   
第一步中返回的100条数据中loan_req_no=LP622990xxxx8176的应该与做为主键查询返回单行数据保持一致，loan_no真实数据为空，而不是被替换的值
   
   ### How to Reproduce?
   
   _No response_
   
   ### Anything Else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of 
Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org