deploy/ch-cold/scripts/sql_migrations/0001_distribute_tables.sql

rename table otel.otel_logs to otel.otel_logs_local;
create table otel.otel_logs as otel.otel_logs_local  ENGINE = Distributed(default, otel, otel_logs_local, rand());

rename table otel.otel_metrics_exponential_histogram to otel.otel_metrics_exponential_histogram_local;
create table otel.otel_metrics_exponential_histogram  as otel.otel_metrics_exponential_histogram_local  ENGINE = Distributed(default, otel, otel_metrics_exponential_histogram_local, rand());

rename table otel.otel_metrics_gauge to otel.otel_metrics_gauge_local;
create table otel.otel_metrics_gauge  as otel.otel_metrics_gauge_local  ENGINE = Distributed(default, otel, otel_metrics_gauge_local, rand());

rename table otel.otel_metrics_histogram to otel.otel_metrics_histogram_local;
create table otel.otel_metrics_histogram  as otel.otel_metrics_histogram_local  ENGINE = Distributed(default, otel, otel_metrics_histogram_local, rand());

rename table otel.otel_metrics_sum to otel.otel_metrics_sum_local;
create table otel.otel_metrics_sum  as otel.otel_metrics_sum_local  ENGINE = Distributed(default, otel, otel_metrics_sum_local, rand());

rename table otel.otel_metrics_summary to otel.otel_metrics_summary_local;
create table otel.otel_metrics_summary  as otel.otel_metrics_summary_local  ENGINE = Distributed(default, otel, otel_metrics_summary_local, rand());

rename table otel.otel_traces to otel.otel_traces_local;
create table otel.otel_traces  as otel.otel_traces_local  ENGINE = Distributed(default, otel, otel_traces_local, rand());

rename table otel.otel_traces_flat_spring_boot to otel.otel_traces_flat_spring_boot_local;
create table otel.otel_traces_flat_spring_boot  as otel.otel_traces_flat_spring_boot_local  ENGINE = Distributed(default, otel, otel.otel_traces_flat_spring_boot_local, rand());