Help wanted!

The following content of this documentation page has been machine-translated. But unlike other websites, it is not done on the fly. This translated text lives on GitHub repository alongside main ClickHouse codebase and waits for fellow native speakers to make it more human-readable. You can also use the original English version as a reference.

Help ClickHouse documentation by editing this page

系统。动物园管理员

如果未配置ZooKeeper,则表不存在。 允许从配置中定义的ZooKeeper集群读取数据。
查询必须具有 ‘path’ WHERE子句中的相等条件或者在某个集合中的条件。 这是ZooKeeper中您想要获取数据的孩子的路径。

查询 SELECT * FROM system.zookeeper WHERE path = '/clickhouse' 输出对所有孩子的数据 /clickhouse 节点。
要输出所有根节点的数据,write path= ‘/’.
如果在指定的路径 ‘path’ 不存在,将引发异常。

查询SELECT * FROM system.zookeeper WHERE path IN ('/', '/clickhouse') 输出//clickhouse节点上所有子节点的数据。
如果在指定的 ‘path’ 集合中有不存在的路径,将引发异常。
它可以用来做一批ZooKeeper路径查询。

列:

  • name (String) — The name of the node.
  • path (String) — The path to the node.
  • value (String) — Node value.
  • dataLength (Int32) — Size of the value.
  • numChildren (Int32) — Number of descendants.
  • czxid (Int64) — ID of the transaction that created the node.
  • mzxid (Int64) — ID of the transaction that last changed the node.
  • pzxid (Int64) — ID of the transaction that last deleted or added descendants.
  • ctime (DateTime) — Time of node creation.
  • mtime (DateTime) — Time of the last modification of the node.
  • version (Int32) — Node version: the number of times the node was changed.
  • cversion (Int32) — Number of added or removed descendants.
  • aversion (Int32) — Number of changes to the ACL.
  • ephemeralOwner (Int64) — For ephemeral nodes, the ID of the session that owns this node.

示例:

  1. SELECT *
  2. FROM system.zookeeper
  3. WHERE path = '/clickhouse/tables/01-08/visits/replicas'
  4. FORMAT Vertical
  1. Row 1:
  2. ──────
  3. name: example01-08-1.yandex.ru
  4. value:
  5. czxid: 932998691229
  6. mzxid: 932998691229
  7. ctime: 2015-03-27 16:49:51
  8. mtime: 2015-03-27 16:49:51
  9. version: 0
  10. cversion: 47
  11. aversion: 0
  12. ephemeralOwner: 0
  13. dataLength: 0
  14. numChildren: 7
  15. pzxid: 987021031383
  16. path: /clickhouse/tables/01-08/visits/replicas
  17. Row 2:
  18. ──────
  19. name: example01-08-2.yandex.ru
  20. value:
  21. czxid: 933002738135
  22. mzxid: 933002738135
  23. ctime: 2015-03-27 16:57:01
  24. mtime: 2015-03-27 16:57:01
  25. version: 0
  26. cversion: 37
  27. aversion: 0
  28. ephemeralOwner: 0
  29. dataLength: 0
  30. numChildren: 7
  31. pzxid: 987021252247
  32. path: /clickhouse/tables/01-08/visits/replicas