Distributed DDL queries (ON CLUSTER clause)报错

发布于 2 年前 作者 clickhousesss 4648 次浏览 来自 问答

官方这个怎么用,报错啊? Distributed DDL queries (ON CLUSTER clause): The CREATE, DROP, ALTER, and RENAME queries support distributed execution on a cluster. For example, the following query creates the all_hits Distributed table on each host in cluster: ** CREATE TABLE IF NOT EXISTS all_hits ON CLUSTER cluster (p Date, i Int32) ENGINE = Distributed(cluster, default, hits) **

3b26644b-ade1-4f7f-8f0f-bb9424741bfc :) CREATE TABLE IF NOT EXISTS all_hits ON CLUSTER monitordata_ck_cluster (p Date, i Int32) ENGINE = Distributed(cluster, default, hits) CREATE TABLE IF NOT EXISTS all_hits ON CLUSTER monitordata_ck_cluster ( p Date, i Int32 ) ENGINE = Distributed(cluster, default, hits)

Received exception from server (version 18.14.8): Code: 49. DB::Exception: Received from 127.0.0.1:9000**. DB::Exception: DDL background thread is not initialized… **

0 rows in set. Elapsed: 0.001 sec.

2 回复

config.xml加上zk配置就好了~

遇到了在20.8.3版本中,即使关联了zk也不行。

回到顶部