sr bitmap
BITMAP_CONTAINS(bitmap, input)
select bitmap_contains(
(select uid_set from
tmp_to_del___user_segment_result where segment_id=545
order by create_time desc limit 1
)
,816596700)
bitmap_contains | StarRocks https://docs.starrocks.io/zh/docs/sql-reference/sql-functions/bitmap-functions/bitmap_contains/
and create_time<'2024-11-17 00:00:00'
and (bitmap_contains(
(select uid_set
from tmp_to_del___user_segment_result
where segment_id="496"
and shop_id=123
order by create_time desc
limit 1
)
,user_id)
)
