clickhouse安装和bitmap测试

安装

docker安装clickhouse：
https://hub.docker.com/r/clickhouse/clickhouse-server

创建库

create database if not exists test ;

创建表

create table test.user_tag1(
    id Int64 ,
    user String,
    bit AggregateFunction(groupBitmap, UInt32),
    create_date date 
)
ENGINE = MergeTree(create_date, (id), 8000)

数据操作

--插入
insert into user_tag1 select toUInt64(2),100,bitmapBuild([toUInt32(1