/
azathd
/
mutiagent
Обзор
Документация
Войти
/
azathd
/
mutiagent
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
deploy/clickhouse-init.sql
45 строк
1 KB
Your Name
init
15 май 2026, 18:31
15 май 2026, 18:31
93097c2
Код
Авторство
О чём код?
CREATE TABLE IF NOT EXISTS events_raw ( occurred_at DateTime, user_email Nullable(String), source_ip Nullable(String), dest_host Nullable(String), dest_port Nullable(UInt16), protocol Nullable(String), bytes_up UInt64, bytes_down UInt64, country Nullable(String), asn Nullable(String), inbound_tag Nullable(String), outbound_tag Nullable(String) ) ENGINE = MergeTree() PARTITION BY toYYYYMMDD(occurred_at) ORDER BY (occurred_at) TTL occurred_at + INTERVAL 90 DAY; CREATE TABLE IF NOT EXISTS events_hourly ( hour DateTime, user_email String, country String, total_bytes UInt64, event_count UInt64 ) ENGINE = SummingMergeTree() PARTITION BY toYYYYMMDD(hour) ORDER BY (hour, user_email, country); CREATE MATERIALIZED VIEW IF NOT EXISTS events_hourly_mv TO events_hourly AS SELECT hour, user_email, country, sum(bytes) AS total_bytes, count() AS event_count FROM ( SELECT toStartOfHour(occurred_at) AS hour, coalesce(user_email, '') AS user_email, coalesce(country, '') AS country, bytes_up + bytes_down AS bytes FROM events_raw ) GROUP BY hour, user_email, country;