clickhosue 分布式表创建示例

示例：

create table test.test_local on cluster cluster_3shards_2replicas(
tracker_channel String,
campaign String,
os String,
state String,
install_adid String,
reg_adid String,
pay_pid String,
pay_price Float64,
gn String,
ds String 
) 
ENGINE = ReplicatedMergeTree('/clickhouse/tables/{shard}/test_local',
 '{replica}') 
 PARTITION BY toYYYYMM(toDate(ds))
ORDER BY (tracker_channel,
campaign,
os,
state,install_adid,reg_adid,pay_pid,pay_price,gn,ds
 )
SETTINGS index_granularity = 1024 ;

-----------------------------------------------

create table test.test_all on cluster cluster_3shards_2replicas(
tracker_channel String,
campaign String,
os String,
state String,
install_adid String,
reg_adid String,
pay_pid String,
pay_price Float64,
gn String,
ds String 
) 
ENGINE = Distributed('cluster_3shards_2replicas',
 'test',
 'test_local',
 rand())　

 

注：ReplicatedReplacingMergeTree在分布式表中也是起到去重作用的

官网：https://clickhouse.com/docs/en/engines/table-engines/mergetree-family/replication

 参考：ClickHouse复制表、分布式表机制与使用方法