6 ms·
It'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 won
by dangoodmanUT 1mo ago
It'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.
- ghshephard 1mo agoHave 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?
- Pedro_Ribeiro 1mo agoI've had some use cases with low latency requirements and frequent data updates. If you want to serve data on a frontend fast it's often not feasible to recompute everything every time
- hantusk 1mo agoIt is implemented here as DuckDB extension: https://github.com/ila/openivm/ https://github.com/ila/openivm/