Comment on PolyScale and ClickHouse Materialized ViewsparentComments−hodgesrm4yClickHouse 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-win...Disclaimer: I work for Altinity. Polyscale is a customer.−benjaminwootton4yI did a deep dive video on some of the options around Clickhouse materialised views too:https://m.youtube.com/watch?v=i7VYsf1e2qU−fasteo4yRelated 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
Comments
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-win...
Disclaimer: I work for Altinity. Polyscale is a customer.
I did a deep dive video on some of the options around Clickhouse materialised views too:
https://m.youtube.com/watch?v=i7VYsf1e2qU
Related to this and Polyscale use case. Would this work ?
That is, replacing the materialized view if favor of a WINDOW VIEW