clickhouse安装

安装

curl https://clickhouse.com/ | sh

sudo ./clickhouse install

 

注释

vi /etc/clickhouse-server/config.xml
#取消下行注释
<!-- <listen_host>::</listen_host> -->
# 9009可能会被占用，起不来的时候注意下

 

修改密码

vi /etc/clickhouse-server/users.xml
#修改密码
<password></password>

 

启动

sudo clickhouse start

状态

sudo clickhouse status

 

engine = MergeTree PARTITION BY toYYYYMM(XX)
    PRIMARY KEY (id, XX)
    ORDER BY (id, XXX)
    SETTINGS index_granularity = 8192;