拉取clickhouse镜像
docker pull yandex/clickhouse-server
启动server端
docker run -d --name clickhouse-server --ulimit nofile=262144:262144 -p 9000:9000 yandex/clickhouse-server
进入容器操作数据库
# 进入容器
docker exec -it clickhouse-server /bin/bash
# 进入clickhouse命令行
clickhouse-client
# 显示数据库
show databases
# 选择数据库
use default
# 显示表
show tables
# 创建表
CREATE TABLE IF NOT EXISTS log_gather2
(
branch String COMMENT '分支',
ten_id Nullable(String) COMMENT '租户Id',
sys_id Nullable(String) COMMENT '系统Id'
) ENGINE = MergeTree() PARTITION BY branch
ORDER BY (branch)
PRIMARY KEY (branch) SETTINGS index_granularity=8192;
# 插入数据
insert into log_gather2 (branch,ten_id,sys_id)
values('bbbb','test','1');
# 查询
select * from log_gather2