2.1.7,创建Bitmap索引失败

Viewed 41

Bitmap索引是Doris 3.0才支持的吗?部署的是apache-doris-2.1.7
创建Bitmap索引成功,但是show create table却展示的是INVERTED类型索引?

https://doris.apache.org/zh-CN/docs/3.0/table-design/best-practice#26-bitmap-索引

CREATE TABLE tbl_user_02 (
    user_id INT,
    site_id INT,
    name VARCHAR(255),
    email VARCHAR(255)
)
DISTRIBUTED BY HASH(`user_id`) BUCKETS 3
PROPERTIES("replication_num" = "1");
CREATE INDEX IF NOT EXISTS idx_bitmap ON tbl_user_02 (site_id) USING BITMAP COMMENT 'bitmap_siteid';
2 Answers

按照2.1的文档,https://doris.apache.org/zh-CN/docs/table-design/index/index-overview
image.png