創(chuàng)建復(fù)制表

use replic_db;
CREATE TABLE retest on cluster cluster_2shards_2replicas(
    x UInt32
) ENGINE = ReplicatedMergeTree('/clickhouse/tables/{shard}/{database}/retest', '{replica}') 
ORDER BY x;

創(chuàng)建分布式表

use replic_db;
CREATE TABLE   retest_all_1  
on cluster cluster_2shards_2replicas AS replic_db.retest ENGINE = Distributed(cluster_2shards_2replicas, replic_db, retest, rand());

添加默認(rèn)的zk路徑

vim /etc/clickhouse-server/conf/config.xml
<default_replica_path>/clickhouse/tables/{shard}/{database}/{table}</default_replica_path>
<default_replica_name>{replica}</default_replica_name>

在創(chuàng)建ReplicatedMergeTree 不需要指定參數(shù)

CREATE TABLE retest_def on cluster cluster_2shards_2replicas(
x UInt32
) ENGINE = ReplicatedMergeTree
ORDER BY x;

CREATE TABLE gl_test.events on cluster cluster_2shards_2replicas
(
    `event` String,
    `distinct_id` String,
    `time` DateTime,
    `pagetitle` String,
    `pagecontroller` String,
    `http_referer` String,
    `keyword` String,
    `latest_scene` String,
    `scene` String,
    `productdbpid` String,
    `url_path` String
)
ENGINE = ReplicatedMergeTree
PARTITION BY toYYYYMMDD(time)
ORDER BY time

CREATE TABLE gl_test.events_all
on cluster cluster_2shards_2replicas
 AS gl_test.events 
ENGINE = Distributed('cluster_2shards_2replicas', 'gl_test', 'events', rand())