3 ms·
ClickHouse has a couple of features along this line: live views and window views. Here's a blog that compares them. https://altinity.com/blog/battle-of-the-vie
by hodgesrm 4y ago
ClickHouse has a couple of features along this line: live views and window views. Here's a blog that compares them.
https://altinity.com/blog/battle-of-the-views-clickhouse-window-view-vs-live-view https://altinity.com/blog/battle-of-the-views-clickhouse-win...
Disclaimer: I work for Altinity. Polyscale is a customer.
- fasteo 4y agoRelated to this and Polyscale use case. Would this work ? CREATE WINDOW VIEW IF NOT EXISTS minute_metrics_wv minute_metrics_tt AS SELECT ... FROM raw_metrics WHERE ... GROUP BY ... That is, replacing the materialized view if favor of a WINDOW VIEW
- benjaminwootton 4y agoI did a deep dive video on some of the options around Clickhouse materialised views too: https://m.youtube.com/watch?v=i7VYsf1e2qU https://m.youtube.com/watch?v=i7VYsf1e2qU