clickhouse-backup icon indicating copy to clipboard operation
clickhouse-backup copied to clipboard

Add options which allow restore non sharded replicated tables

Open Slach opened this issue 6 months ago • 0 comments

CLICKHOUSE_SKIP_RESTORE_NON_SHARDED_REPLICATED_TABLES - false / 0 default value CLICKHOUSE_SKIP_CHECK_NON_SHARDED_REPLICATED_TABLES_CLUSTER - with {cluster} default value

use following query to check global tables

SELECT database, table, if(uniqExact(zookeeper_path) = 1 AND count() > 1,'global','sharded') AS type 
FROM clusterAllReplicas('{cluster}', system.replicas)
GROUP BY database, table
HAVING type='global'

Slach avatar Jul 09 '25 13:07 Slach