CREATE MATERIALIZED VIEW counter_daily_mv TO counter_daily AS SELECT toStartOfDay(when)

Question

CREATE MATERIALIZED VIEW counter_daily_mv TO counter_daily AS SELECT toStartOfDay(when)

as day,
device,
count(*) as count,
maxState(value) AS max_value_state,
minState(value) AS min_value_state,
avgState(value) AS avg_value_state
FROM counter
WHERE when >= toDate('2019-01-01 00:00:00')
GROUP BY device, day
ORDER BY device, day
у altinity есть такой пример.
А можно сделать toStartOfDay(when) as when как-то?

#backend #clickhouse #database #devops #programming #russian

0

20.03.2020

1 ответов

14 просмотров

Dmitry [Altinity] Titov · Accepted Answer

Dmitry [Altinity] Titov

можно но работает это не самым предсказуемым образом

0

20.03.2020

184 похожих чатов

CREATE MATERIALIZED VIEW counter_daily_mv TO counter_daily AS SELECT toStartOfDay(when)

1 ответов

Похожие вопросы