Clickhouse Database: Tables vs Distributed Tables

TLDR Roger asked about differences between tables and distributed tables in Clickhouse. Ankit explained that queries should be run against distributed tables, while non-distributed tables exist in each shard.

Photo of Roger
Roger
Sat, 18 Feb 2023 21:22:22 UTC

In the Clickhouse database, there are both tables and distributed tables. are they identical in terms of usage, just that you can configure it to use the distributed Clickhouse engine or are there some logic in signoz which decides when to use what?

Photo of Ankit
Ankit
Sun, 19 Feb 2023 12:00:30 UTC

Roger queries should be run against `distributed_` tables. Non distributed tables exist in each shard. If you use table names without `distributed_` , you would be querying against a specific shard