描述
显示此 ClickHouse server 当前在 ZooKeeper 节点 (包括辅助 ZooKeeper) 上注册的活动 watch。每一行表示一个 watch。 可用性system.zookeeper_watches 仅在配置了 ClickHouse Keeper 或 ZooKeeper 时存在。在两者均未配置的服务器上，该表不存在，对其执行的查询会以 UNKNOWN_TABLE 错误失败。
列
zookeeper_name(String) — ZooKeeper 连接的名称 (主连接为 “default”，或辅助连接名称) 。create_time(DateTime) — watch 创建的时间。create_time_microseconds(DateTime64(6)) — 以微秒精度记录的 watch 创建时间。path(String) — 被 watch 监听的 ZooKeeper 路径。session_id(Int64) — 注册该 watch 的连接的会话 ID。request_xid(Int64) — 创建该 watch 的请求的 XID。op_num(Enum16(‘Close’ = -11, ‘Error’ = -1, ‘Watch’ = 0, ‘Create’ = 1, ‘Remove’ = 2, ‘Exists’ = 3, ‘Get’ = 4, ‘Set’ = 5, ‘GetACL’ = 6, ‘SetACL’ = 7, ‘SimpleList’ = 8, ‘Sync’ = 9, ‘Heartbeat’ = 11, ‘List’ = 12, ‘Check’ = 13, ‘Multi’ = 14, ‘Create2’ = 15, ‘Reconfig’ = 16, ‘CheckWatch’ = 17, ‘RemoveWatch’ = 18, ‘CreateContainer’ = 19, ‘CreateTTL’ = 21, ‘MultiRead’ = 22, ‘Auth’ = 100, ‘SetWatch’ = 101, ‘SetWatch2’ = 105, ‘AddWatch’ = 106, ‘FilteredList’ = 500, ‘CheckNotExists’ = 501, ‘CreateIfNotExists’ = 502, ‘RemoveRecursive’ = 503, ‘CheckStat’ = 504, ‘TryRemove’ = 505, ‘FilteredListWithStatsAndData’ = 506, ‘ListRecursive’ = 507, ‘SessionID’ = 997)) — 创建该 watch 的操作。watch_type(Enum8(‘Unexpected’ = -1, ‘Children’ = 1, ‘Exists’ = 2, ‘Data’ = 3)) — watch 类型：Children (list) 、Exists 或 Data (get) 。