version 20.3.5, event_date中还存在2021-11-16的数据:
CREATE TABLE web_event(
server_time
DateTime64(3, ‘Asia/Shanghai’),
app_id
String,
messageid
String,
event_id
String,
activity
String,
event_date
Date DEFAULT CAST(server_time, ‘Date’),
ck_dt
DateTime64(3, ‘Asia/Shanghai’) DEFAULT now64(3)
)
ENGINE = ReplacingMergeTree() PARTITION BY formatDateTime(server_time, ‘%Y%m%d%H’)
ORDER BY(server_time, messageid)
TTL event_date + toIntervalDay(31)
SETTINGS index_granularity = 8192