v20.5.3.27-stable

CREATE TABLE events
(
    `event` String,
    `event_date` Date DEFAULT toDate(event_time),
    `event_time` DateTime,
    `event_id` UInt32,
    `id_num_0` Float64,
    `id_num_1` Float64,
    `id_num_2` Float64,
    `id_num_3` Float64,
    `id_num_4` Float64,
    `id_num_5` Float64,
    `id_num_6` Float64,
    `id_num_7` Float64,
    `id_num_8` Float64,
    `id_num_9` Float64,
    `id_str_0` String,
    `id_str_1` String,
    `id_str_2` String,
    `id_str_3` String,
    `id_str_4` String,
    `id_str_5` String,
    `id_str_6` String,
    `id_str_7` String,
    `id_str_8` String,
    `id_str_9` String,
    `state_num_0` Float64,
    `state_num_1` Float64,
    `state_num_2` Float64,
    `state_num_3` Float64,
    `state_num_4` Float64,
    `state_num_5` Float64,
    `state_num_6` Float64,
    `state_num_7` Float64,
    `state_num_8` Float64,
    `state_num_9` Float64,
    `state_str_0` String,
    `state_str_1` String,
    `state_str_2` String,
    `state_str_3` String,
    `state_str_4` String,
    `state_str_5` String,
    `state_str_6` String,
    `state_str_7` String,
    `state_str_8` String,
    `state_str_9` String,
    `state_str_10` String,
    `state_str_11` String,
    `state_str_12` String,
    `state_str_13` String,
    `state_str_14` String,
    `state_str_15` String
)
ENGINE = ReplacingMergeTree(event_time)
PARTITION BY toYYYYMM(event_date)
ORDER BY (event,
 event_date,
 event_time,
 event_id,
 id_num_0,
 id_num_1,
 id_num_2,
 id_num_3,
 id_num_4,
 id_num_5,
 id_num_6,
 id_num_7,
 id_num_8,
 id_num_9,
 id_str_0,
 id_str_1,
 id_str_2,
 id_str_3,
 id_str_4,
 id_str_5,
 id_str_6,
 id_str_7,
 id_str_8,
 id_str_9)
SETTINGS index_granularity = 8192