1. 部署结构
在Clickhouse中, 一般的有2种部署方式,3种使用方式:
部署方式:
使用方式:
下面简单介绍集群化操作和单节点操作的基本SQL。
create database db_test on cluster default_cluster
drop database db_test on cluster default_cluster
CREATE TABLE db_test.tbl_replac_merge_test on cluster default_cluster(
id String,
code String,
creat_time DateTime
)
ENGINE = ReplacingMergeTree()
PARTITION BY toYYYYMM(create_time)
PRIMARY KEY id
ORDER BY (id, code);
drop table db_test.tbl_replac_merge_test on cluster default_cluster
create database db_test;
drop database db_test;
CREATE TABLE db_test.tbl_replac_merge_test(`id` String,
`code` String,
`create_time` DateTime
)
ENGINE = ReplacingMergeTree()
PARTITION BY toYYYYMM(create_time)
PRIMARY KEY id
ORDER BY (id, code);
drop table db_tetbl_replac_merge_test
更多Clickhouse建表文档:
https://clickhouse.tech/docs/en/sql-reference/statements/create/table/