News for hackers. Stuff that matters.
Re:PolyScale and ClickHouse Materialized Views by hodgesrm on Wednesday August 17, 2022 @11:05AM (#32497377)
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.

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:

https://m.youtube.com/watch?v=i7VYsf1e2qU

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