Querying in ClickHouse CloudThe data in this system table is held locally on each node in ClickHouse Cloud. Obtaining a complete view of all data, therefore, requires the
clusterAllReplicas function. See here for further details.Description
This table outputs combined introspection about zookeeper and the nodes are taken from config. Availabilitysystem.zookeeper_info exists only when ClickHouse Keeper or ZooKeeper is configured. On servers without either configured, the table does not exist and queries against it will fail with UNKNOWN_TABLE.
Columns
zookeeper_cluster_name(String) — ZooKeeper cluster’s name.host(String) — The hostname/IP of the ZooKeeper node that ClickHouse connected to.port(UInt16) — The port of the ZooKeeper node that ClickHouse connected to.index(Nullable(UInt8)) — The index of the ZooKeeper node that ClickHouse connected to. The index is from ZooKeeper config. If not connected, this column is NULL.is_connected(UInt8) — Is the zookeeper connected.is_readonly(Nullable(UInt8)) — Is readonly.version(Nullable(String)) — The ZooKeeper version.avg_latency(Nullable(UInt64)) — The average latency.max_latency(Nullable(UInt64)) — The max latency.min_latency(Nullable(UInt64)) — The min latency.packets_received(Nullable(UInt64)) — The number of packets received.packets_sent(Nullable(UInt64)) — The number of packets sent.outstanding_requests(Nullable(UInt64)) — The number of outstanding requests.server_state(Nullable(String)) — Server state.is_leader(Nullable(UInt8)) — Is this zookeeper leader.znode_count(Nullable(UInt64)) — The znode count.watch_count(Nullable(UInt64)) — The watch count.ephemerals_count(Nullable(UInt64)) — The ephemerals count.approximate_data_size(Nullable(UInt64)) — The approximate data size.followers(Nullable(UInt64)) — The followers of the leader. This field is only exposed by the leader.synced_followers(Nullable(UInt64)) — The synced followers of the leader. This field is only exposed by the leader.pending_syncs(Nullable(UInt64)) — The pending syncs of the leader. This field is only exposed by the leader.open_file_descriptor_count(Nullable(UInt64)) — The open file descriptor count. Only available on Unix platforms.max_file_descriptor_count(Nullable(UInt64)) — The max file descriptor count. Only available on Unix platforms.connections(Nullable(UInt64)) — The ZooKeeper connections.outstanding(Nullable(UInt64)) — The ZooKeeper outstanding.zxid(Nullable(Int64)) — The ZooKeeper zxid.node_count(Nullable(UInt64)) — The ZooKeeper node count.snapshot_dir_size(Nullable(UInt64)) — The ZooKeeper snapshot directory size.log_dir_size(Nullable(UInt64)) — The ZooKeeper log directory size.first_log_idx(Nullable(UInt64)) — The ZooKeeper first log index.first_log_term(Nullable(UInt64)) — The ZooKeeper first log term.last_log_idx(Nullable(UInt64)) — The ZooKeeper last log index.last_log_term(Nullable(UInt64)) — The ZooKeeper last log term.last_committed_idx(Nullable(UInt64)) — The ZooKeeper last committed index.leader_committed_log_idx(Nullable(UInt64)) — The ZooKeeper leader committed log index.target_committed_log_idx(Nullable(UInt64)) — The ZooKeeper target committed log index.last_snapshot_idx(Nullable(UInt64)) — The ZooKeeper last snapshot index.