Skip to content

Add options which allow restore non sharded replicated tables #1181

@Slach

Description

@Slach

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'

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions