Distributed DDL queries (ON CLUSTER clause)报错
发布于 2 个月前 作者 clickhousesss 259 次浏览 来自 问答

官方这个怎么用,报错啊? 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.

1 回复

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

回到顶部