#869·goose

Add support to replicated clickhouse cluster

Author: jderusseCreated Dec 11, 2024Updated Sep 4, 2026
Labelsclickhouseup next

When running goose on a clickhouse cluster, it fails to get the list of "previous" migrations (sometime querying a node a get a partial list of migrations)

Possible fix:

  1. change the engine
diff
- ENGINE = MergeTree()
+ ENGINE = ReplicatedMergeTree('/clickhouse/{cluster}/tables/{shard}/{database}/{table}', '{replica}')

Not sure how this can be defined in goose via the CreateTable function (or should it be a new driver ? :thinking: )