安装
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