Closed
Description
Because system tables are local per node and can be versioned (query_log.1
, .2
, etc.) the correct syntax to query all data esp. in ClickHouse Cloud is something like FROM clusterAllReplicas('default', merge('system', '^query_log.*'))
. We should document this somewhere, probably https://clickhouse.com/docs/operations/system-tables/overview#system-tables-in-clickhouse-cloud.