clickhouse分布式建时遇到的坑----There is no Zookeeper configuration in server config. (NO_ELEMENTS_IN_CONFIG)
clickhouse建表语句create table st_order_mt_0105_all on cluster test_cluster_one_shard_three_replicas_localhost(id UInt32,sku_id String,total_amount Decimal(16,2),...
·
clickhouse建表语句
create table st_order_mt_0105_all on cluster test_cluster_one_shard_three_replicas_localhost
(
id UInt32,
sku_id String,
total_amount Decimal(16,2),
create_time Datetime
)engine = Distributed(test_cluster_one_shard_three_replicas_localhost,test0105,st_order_mt_0105,hiveHash(sku_id));
报错如下
Query id: cad6a6d4-0980-4fb9-8e4f-2dbae9362ffa 0 rows in set. Elapsed: 0.005 sec. Received exception from server (version 22.3.2): Code: 139. DB::Exception: Received from 192.168.40.92:9977. DB::Exception: There is no Zookeeper configuration in server config. (NO_ELEMENTS_IN_CONFIG)
报错提示zookeeper 配置未找到,但是在config.xml中已经配置了zookeeper如下
<zookeeper-servers>
<node index="1">
<host>192.168.40.90</host>
<port>2181</port>
</node>
<node index="2">
<host>192.168.40.91</host>
<port>2181</port>
</node>
<node index="3">
<host>192.168.40.92</host>
<port>2181</port>
</node>
</zookeeper-servers>
访问clickhouse官网查看配置说明找到配置事例如下
<zookeeper>
<node>
<host>zoo01.yandex.ru</host>
<port>2181</port>
</node>
<node>
<host>zoo02.yandex.ru</host>
<port>2181</port>
</node>
<node>
<host>zoo03.yandex.ru</host>
<port>2181</port>
</node>
</zookeeper>
wq保存配置异常解除,创建分布式表成功,有问题多看官网!
已为社区贡献1条内容
所有评论(0)