DC
SELECT *
FROM system.clusters
WHERE cluster = 'perftest_3shards'
FORMAT Vertical;
возвращает все три сервера
>у меня все данные остаются на той ноде
в смысле select count() показывает нужно кол-во на ноде-инициаторе? А на остальных нодах 0 строк?
Size: a a a
DC
SELECT *
FROM system.clusters
WHERE cluster = 'perftest_3shards'
FORMAT Vertical;
N
DC
N
Row 1:
──────
cluster: perftest_3shards
shard_num: 1
shard_weight: 1
replica_num: 1
host_name: 35.158.138.58
host_address: 35.158.138.58
port: 9000
is_local: 0
user: default
default_database:
errors_count: 0
estimated_recovery_time: 0
Row 2:
──────
cluster: perftest_3shards
shard_num: 2
shard_weight: 1
replica_num: 1
host_name: 18.196.146.211
host_address: 18.196.146.211
port: 9000
is_local: 0
user: default
default_database:
errors_count: 0
estimated_recovery_time: 0
Row 3:
──────
cluster: perftest_3shards
shard_num: 3
shard_weight: 1
replica_num: 1
host_name: 18.184.241.98
host_address: 18.184.241.98
port: 9000
is_local: 0
user: default
default_database:
errors_count: 0
estimated_recovery_time: 0
3 rows in set. Elapsed: 0.002 sec.
N
DC
select count() from trips_mergetree_third
c каждой нодыN
select count() from trips_mergetree_third
c каждой нодыN
DC
N
N
AM
inflate failed: buffer error
IN:INSERT INTO gmc_item_distributed ( gmc_id,item_id,country_code,label_code,updated_at,flag ) FORMAT TabSeparated
DC
AM
DC
AM
D
RG