i tried signoz distributed clickhouse, migration (sync and async) success. but there are some missing tables inside clickhouse-2 and clickhouse-3...for example signoz_metrics.samples_v4 missing on clickhouse-2 clickhouse-3.

Did you enable the distributed CH when you were setting up or later?

thanks for replying, Srikanth! i enabled distributed CH later after installation, i think the migration failed because when i checked inside the signoz_metrics database from clickhouse-2 and clickhouse-3, there exist only 2 table: • distributed_schema_migrations_v2 • schema_migrations_v2

rerun the migrations pointing to each of the instances rather than pointing to the service because if the migration targets the instance which already has the schema, it won't create them. See the migrator command and update the dsn to point to instance which has schemas missing