incubator-doris Bitmap with union And bitmap_intersect

pinkon5k 于 2022-04-22 发布在 Java

关注(0)|答案(1)|浏览(270)

Describe the bug

1）Bitmap does not support UNIONS
2）The bitmap_intersect function always returns a value of 0

To Reproduce

Steps to reproduce the behavior:
1）

SELECT
bitmap_from_string ('1,2,3,4,5') AS a
UNION
SELECT
bitmap_from_string ('1,2,3,4,5,6') AS a

2）

select 	bitmap_count(bitmap_intersect(fid_bitmap)) from
feature_bitmap_tmp where feature_value = '1' or feature_value = '2'

use Doris-0.13.15 and Doris-0.12.13

1条答案

In fact, Doris supports the union of bitmap, and the query method is bitmap_union. To find the union of multiple bitmap values.

The union of bitmap is actually supported, or can you give a complete example of the final calculation error of the original data?