版本:2.0.12
agg模型的表,其中key为pt、code,value为code_bm
CREATE TABLE ad (
pt date,
code varchar(100),
code_bm bitmap BITMAP_UNION,
xxx
)
如下两个查询耗时差不多,bitmap字段加速效果不明显,这个要如何排查呢?
select
pt,
count(distinct code)
from
ad
where
pt between '20230101' and '20231231'
group by
pt
select
pt,
count(distinct code_bm)
from
ad
where
pt between '20230101' and '20231231'
group by
pt