Size: a a a
E
DC
DC
DC
CREATE TABLE default.messages (материализованное представление и таблицу, в которой хочу суммировать данные
`event_date_time` DateTime,
`system_generated_id` Int64,
......
`registration_tu_code` Nullable(Int64) MATERIALIZED (SUBSTRING(registration_customs_code,1,3)),
`registration_date` Nullable(Date),
`registration_logbook_number` Nullable(String)
) ENGINE = MergeTree PARTITION BY toYYYYMM(event_date_time) ORDER BY (system_generated_id) SETTINGS index_granularity = 8192;
Создаю
CREATE TABLE default.m (
`day` Date ,
`message_dir` Int8
)
ENGINE = SummingMergeTree() PARTITION BY tuple() ORDER BY (day) SETTINGS index_granularity = 8192;
CREATE MATERIALIZED VIEW default.m_mv TO default.m (
`day` Date ,
`message_dir` Int8
) as
select
toStartOfDay(event_date_time) as day,
message_direction
from default.messages;
но в таблице default.m вижу результат :D
D
S
ТИ
S
DC
DC
E
S
TM
DC
TM
DC
E
AggregatingMergeTree (для AggregateFunction колонки)?DT
AggregatingMergeTree (для AggregateFunction колонки)?E