1.2及版本以下建表没有问题
建表语句如下
CREATE TABLE t_tag_bitmap (
tag varchar(10) NULL COMMENT "",
user_id bitmap BITMAP_UNION NULL COMMENT ""
) ENGINE=OLAP
AGGREGATE KEY(tag)
COMMENT "OLAP"
DISTRIBUTED BY HASH(tag) BUCKETS 5
PROPERTIES (
"replication_num" = "3",
"in_memory" = "false",
"storage_format" = "V2"
);
MySQL [test]> describe t_tag_bitmap;
+---------+-------------+------+-------+---------+--------------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-------+---------+--------------+
| tag | varchar(10) | Yes | true | NULL | |
| user_id | bitmap | No | false | | BITMAP_UNION |
+---------+-------------+------+-------+---------+--------------+
查看建表语句
show create table t_tag_bitmap;
| t_tag_bitmap | CREATE TABLE t_tag_bitmap (
tag varchar(10) NULL,
user_id bitmap BITMAP_UNION NOT NULL
) ENGINE=OLAP
AGGREGATE KEY(tag)
COMMENT 'OLAP'
DISTRIBUTED BY HASH(tag) BUCKETS 5
PROPERTIES (
"replication_allocation" = "tag.location.default: 3",
"min_load_replica_num" = "-1",
"is_being_synced" = "false",
"storage_medium" = "ssd",
"storage_format" = "V2",
"inverted_index_storage_format" = "V1",
"light_schema_change" = "true",
"disable_auto_compaction" = "false",
"enable_single_replica_compaction" = "false",
"group_commit_interval_ms" = "10000",
"group_commit_data_bytes" = "134217728"
);
