实践：在clickhouse中建表

一、docker安装clickhouse

建表前准备:
我现在的环境是:windows10，机子上面有docker
准备在docker里面装clickhouse

1、查询ClickHouse镜像

docker search clickHouse

2、拉取镜像

docker pull yandex/clickhouse-client
docker pull yandex/clickhouse-server

3、启动server端容器

docker run -d --name clickhouse-server --ulimit nofile=262144:262144 --volume=//D/clickhouse:/var/lib/clickhouse yandex/clickhouse-server
c1760937eac6d9838fa356daa30a03acd16c7c7709eeb9c6677b18b98ff19abc

单击”Share it“按钮

4、连接clickhouse-server

docker run -it --rm --link clickhouse-server:clickhouse-server yandex/clickhouse-client --host clickhouse-server

二、建立数据库

CREATE DATABASE zmq;

三、建立数据表

CREATE TABLE zmq.tb_request_record
(
    `id` UInt64 COMMENT '自增ID',
    `uid` UInt64 COMMENT '用户ID',
    `bid` UInt64 COMMENT '书籍ID',
    `chapterno` UInt64 COMMENT '章节排序值',
    `client` UInt8 COMMENT '客户端 1 安卓 2 苹果',
    `ctime` UInt64 COMMENT '创建时间',
    `cdate` Date COMMENT '创建日期'
)
ENGINE = MergeTree
PARTITION BY toYYYYMM(cdate) #
ORDER BY (bid, cdate, uid, chapterno)
SETTINGS index_granularity = 8192;

如果在python脚本中写建表语句时‘id’中的‘’要去掉