v.25.4New Feature
Setting parallel_distributed_insert_select makes effect
The settingparallel_distributed_insert_selectmakes effect forINSERT SELECTintoReplicatedMergeTree(previously it required Distribued tables). #78041 (Igor Nikonov).
Why it matters
This feature enables parallel execution ofINSERT SELECT queries on ReplicatedMergeTree tables, improving insert performance and resource utilization by allowing distributed parallel processing without requiring an intermediary Distributed table.How to use it
To leverage this feature, set theparallel_distributed_insert_select setting to 1 (enabled) before running your INSERT SELECT query targeting a ReplicatedMergeTree table. For example:SET parallel_distributed_insert_select = 1;
INSERT INTO target_table SELECT * FROM source_table;