Aleksey Koltsov
Aleksey Koltsov
`select delete_ttl_info_min delete_ttl_info_max from system.parts where table = 'samples_v3' and active = 1` ``` ┌─delete_ttl_info_min─┬─delete_ttl_info_max─┐ │ 2022-12-11 00:00:00 │ 2022-12-11 18:14:52 │ │ 2022-12-11 18:14:49 │ 2022-12-11 21:12:20 │ │...
> Which version of ClickHouse are you using? ClickHouse server version 22.1.3.7 (official build).
data table settings ``` ┌─statement──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┐ ( `fingerprint` UInt64, `timestamp_ns` Int64 CODEC(DoubleDelta), `value` Float64 CODEC(Gorilla), `string` String ) ENGINE = MergeTree PARTITION BY toStartOfDay(toDateTime(timestamp_ns / 1000000000)) ORDER BY timestamp_ns TTL toDateTime(timestamp_ns...
@akvlad This fresh output ``` ┌─partition───────────┐ │ 2022-12-09 00:00:00 │ │ 2022-12-10 00:00:00 │ │ 2022-12-11 00:00:00 │ │ 2022-12-12 00:00:00 │ │ 2022-12-13 00:00:00 │ │ 2022-12-14 00:00:00 │...