What is the difference between _dist and _local tables in clickhouse?

badihi · April 9, 2022, 3:15pm

I’m trying to query some data from clickhouse database. I can see that there is two of each table, one with prefix _dist and one with _local.
Can you please describe the difference between these two?

Topic		Replies	Views
Clickhouse DB::Exception: Table default.migrations_local doesn't exist On-Premise	9	6421	June 2, 2021
What is stored in ClickHouse and what is stored in Postgres On-Premise	3	8195	July 29, 2020
I am curious about how to connect the sharded multi-node clickhouse On-Premise	8	4115	December 17, 2020
How does sessions_hourly table in Clickhouse get populated	0	571	February 9, 2022
Import older Clickhouse data into new Clickhouse DB? On-Premise	2	793	October 26, 2021

What is the difference between _dist and _local tables in clickhouse?

Related topics