Re:PolyScale and ClickHouse Materialized Views
by benjaminwootton on Wednesday August 17, 2022 @11:27AM
(#32497625)
I did a deep dive video on some of the options around Clickhouse materialised views too:
Re:PolyScale and ClickHouse Materialized Views
by fasteo on Wednesday August 17, 2022 @11:17AM
(#32497515)
Related 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
https://altinity.com/blog/battle-of-the-views-clickhouse-win...
Disclaimer: I work for Altinity. Polyscale is a customer.