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
The table only exists for ClickHouse Keeper deployments that use theclickhouse server (and not clickhouse keeper) process. It contains one row per node of the data tree stored on the local Keeper node, including the /keeper system nodes.
Unlike system.zookeeper, this table does not send requests to a Keeper cluster. It reads the committed state of the local Keeper directly from a consistent lock-free view, without affecting request processing. Reading the table does not require a path condition and returns the whole tree, so it is suitable for queries that scan all nodes, such as finding the nodes with the most children or the largest data.
Columns
path(String) — Absolute path of the node.data(String) — Data stored in the node.czxid(Int64) — ID of the transaction that created the node.mzxid(Int64) — ID of the transaction that last modified the node.ctime(DateTime64(3)) — Time when the node was created.mtime(DateTime64(3)) — Time when the node was last modified.version(Int32) — Number of modifications of the node data.cversion(Int32) — Number of modifications of the node children.aversion(Int32) — Number of modifications of the node ACL.ephemeral_owner(Int64) — ID of the session that owns the node if it is ephemeral,0otherwise.data_length(UInt32) — Size of the node data in bytes.num_children(Int32) — Number of children of the node.pzxid(Int64) — ID of the transaction that last added or removed children of the node.seq_num(Int64) — Counter used to generate names of sequential children of the node.ttl(Int64) — TTL of the node in milliseconds if it is a TTL node,0otherwise.acl_id(UInt32) — Internal ID of the node ACL,0if the node has no ACL.