Clickhouse - is it possible to Alter table in a cluster in 1 command

2
votes

I have a scenario where we need to add columns on a table which exists in several different Clickhouse nodes and queried by a distributed table .

Is there a way to alter that table in all servers, using a single alter command? meaning that the alter command will propagate to all various instances and fail completely if one node fails to commit alter? or do I need to develop a mechanism which knows to run alter on each node, and rollback if one node fails to commit alter?

1
databaseclickhouseyandex

1 Answers

3
votes

alter table xxx on cluster my_cluster add column x Int64;

alter table xxx_dist on cluster my_cluster add column x Int64;