Size: a a a
S
M
DC
Timeout exceeded while receiving data from server. Waited for 300 seconds, timeout is 300 seconds.
Cancelling query.
Ok.
Query was cancelled.
0 rows in set. Elapsed: 566.146 sec.Cancelling query. --- клиент говорит пытаюсь
Ok.
Query was cancelled.АА
ЯК
DV
Cancelling query. --- клиент говорит пытаюсь
Ok.
Query was cancelled.ЯК
АА
DC
DC
АА
DC
CREATE TABLE fff ( tx Int64) ENGINE = MergeTree() ORDER BY (intHash32(tx)) SAMPLE BY intHash32(tx)
insert into fff select number from numbers(10);
select groupArray(tx) from fff sample 0.33 offset 0
[9,6,3,1]
select groupArray(tx) from fff sample 0.33 offset 0.33
[8,2,5]
select groupArray(tx) from fff sample 0.33 offset 0.66
[7,4,0]
--------
select number n, intHash32(n) x from numbers(10) order by x;
┌─n─┬──────────x─┐
│ 9 │ 1241149650 │
│ 6 │ 1295823179 │
│ 3 │ 1298551497 │
│ 1 │ 1343103100 │
│ 8 │ 1618865725 │
│ 2 │ 1996614413 │
│ 5 │ 2641603337 │
│ 7 │ 3844986530 │
│ 4 │ 3902320246 │
│ 0 │ 4249604106 │
└───┴────────────┘
insert into fff select number from numbers(10);
select groupArray(tx) from fff sample 0.33 offset 0
[9,6,3,1,9,6,3,1]
optimize table fff final;
select groupArray(tx) from fff sample 0.33 offset 0
[9,9,6,6,3,3,1,1]
DC
ПП
АА
SELECT partition, name, active FROM system.parts WHERE table=‘table_name’, слева это нормальная реплика, а справа где не хватает данныхK
ПП
ПП
АА
Code: 49, e.displayText() = DB::Exception: Part 202007_178923_183866_158 intersects next part 202007_183866_183876_2 (state Committed). It is a bug. (version 20.5.2.7 (official build))K