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),
                  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官网查看配置说明找到配置事例如下

详情见 使用教程 | 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保存配置异常解除，创建分布式表成功，有问题多看官网！