[GitHub] [doris] zhangkun-pass opened a new issue, #19146: [Bug]

[via GitHub]

zhangkun-pass opened a new issue, #19146:
URL: https://github.com/apache/doris/issues/19146

   ### Search before asking
   
   - [X] I had searched in the 
[issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no 
similar issues.
   
   
   ### Version
   
   1.1.0 和 1.2.3
   
   ### What's Wrong?
   
   写入到Doris的方式是使用的doris的route load将kafka的数据load到Doris
   
   
   doris版本 1.1.0
   bitmap计算的数量实际是2， 走物化视图结果为1
   
   请问这是为什么呢, 从结果上来说这个也不是hash碰撞的原因(之前遇见过, 删除重建物化视图就又正确了) 这是个bug吗
   
   plate_no_hash_id 是通过 bitmap_hash(plate_no) 生成的
   
   sql(本sql不走物化视图 -- 所有存在的字段):
   select DISTINCT plate_no, plate_no_hash_id FROM 
viid_internal_motorvehicle_default WHERE vehicle_class = "H30"
   
   结果:
   
![image](https://user-images.githubusercontent.com/28724178/234774155-40537ed2-cb8f-4f1e-84ee-3b5aeb8f1cb9.png)
   
   
   ##sql 走物化视图的sql(结果为1)
   SELECT bitmap_to_string(bitmap_union(TO_BITMAP(plate_no_hash_id)))
   FROM viid_internal_motorvehicle_default WHERE vehicle_class = "H30"
   
   结果
   
![image](https://user-images.githubusercontent.com/28724178/234774227-c6c047cf-6ee1-4c7d-b602-fb909a564cde.png)
   
   
   --sql 不走物化视图(结构为2)
   SELECT bitmap_to_string(bitmap_union(TO_BITMAP(plate_no_hash_id)))
   FROM viid_internal_motorvehicle_default WHERE vehicle_class = "H30" and 
source_id = 37
   
![image](https://user-images.githubusercontent.com/28724178/234774267-08456a5c-9b2d-47e1-ac14-f4b38eba50e9.png)
   
   
   
   
   
   
   
   当我吧doris版本升级到1.2.3之后依旧存在该问题
   -- 走物化视图union_bitmap()   结果31
   select count(DISTINCT plate_no_hash_id) from 
viid_internal_motorvehicle_default where vehicle_class = "K30"
   
   -- 不走物化视图   结果33
   select count(DISTINCT plate_no_hash_id) from 
viid_internal_motorvehicle_default where vehicle_class = "K30" AND info_kind is 
null
   
   ### What You Expected?
   
   期望sql走物化视图和不走物化视图的结果是一致的
   
   ### 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