clickhouse-backup
clickhouse-backup copied to clipboard
Add options which allow restore non sharded replicated tables
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'