alt Hacker NewsIt's funny to me that we still don't have incremental materialized views. All of the parts are there (export state, agg_state (forget fn name), finalize). I wonder if they're avoiding an explicit war with clickhouse or something. I do recall they mentioned they want to add this to ducklake.
Incremental MVs are ClickHouse's best feature. If DDB adds this, the last moat is distributed query execution.
Replies
ghshephard • yesterday at 11:41 PM
Have you run into scenarios where a simple view doesn't accomplish what you require? I always feel like views do everything I want - because the speed is so great, the full recompute isn't that big a deal.
Maybe it's a bigger deal when you have multiple users/and or more repeated queries against something that's really expensive?
➕ show 1 reply
It is implemented here as DuckDB extension: https://github.com/ila/openivm/