我们在进行bitmap相关操作的时候报错，Unknown error
【背景】bitmap逻辑操作
【业务影响】
【StarRocks版本】例如：2.5.4
SELECT
bitmap_and ((
WITH relation_bitmap AS (
SELECT
label_value,
bitmap_union ( seq_id_bitmap ) AS seq_id_bitmap
FROM
entity_4_label_summary
WHERE
label_id = 0
AND (
cast( source_dt AS date ) >= cast( ‘2023-09-01’ AS date ))
AND (
cast( source_dt AS date ) <= cast( ‘2023-09-01’ AS date ))
GROUP BY
label_value
),
from_entity_bitmap AS ((
SELECT
ifnull(
bitmap_union ( seq_id_bitmap ),
bitmap_empty ()) AS seq_id_bitmap
FROM
entity_4_label_summary
WHERE
label_id = 23
AND label_type = 1
AND update_time = ‘2023-07-26 17:43:54’
AND (
label_value IN ( ‘电信’, ‘移动’, ‘联通’, ‘未知’ )))),
user_id_table AS ( SELECT unnest AS seq_id FROM from_entity_bitmap b, unnest ( bitmap_to_array ( b.seq_id_bitmap )) ) SELECT
IFNULL(
bitmap_union ( rb.seq_id_bitmap ),
bitmap_empty ()) AS seq_id_bitmap
FROM
user_id_table ttt
JOIN relation_bitmap rb ON rb.label_value = ttt.seq_id
),
bitmap_empty ())