v.24.12New Feature
Added support for attaching MergeTree tables as ReplicatedMergeTree and vice versa
Added a query that allows to attachMergeTreetables asReplicatedMergeTreeand vice versa:ATTACH TABLE ... AS REPLICATEDandATTACH TABLE ... AS NOT REPLICATED. #65401 (Kirill).
Why it matters
This feature allows users to convert table replication status at the time of attaching existing tables without needing to recreate or migrate data manually. It simplifies management of replication forMergeTree tables, enabling smoother transitions between replicated and non-replicated table configurations.How to use it
When attaching a table, append the clausesAS REPLICATED to attach it as a ReplicatedMergeTree table, or use AS NOT REPLICATED to attach it as a regular MergeTree table. Example:ATTACH TABLE my_table AS REPLICATEDor
ATTACH TABLE my_table AS NOT REPLICATED