Skip to content

Document using clusterAllReplicas and merge to correctly query system tables #3645

Closed
@cwurm

Description

@cwurm

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.

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions