3 ms·
Basically like a persistent view of data which gets modified when the original table changes? Glad to see more data science friendly features being added. Been
by Narhem 2y ago
Basically like a persistent view of data which gets modified when the original table changes? Glad to see more data science friendly features being added. Been watching Clickhouse for a while now and I am very impressed.
- acossta 2y agoCorrect. Under the hood, they work as insert triggers that automatically update the target whenever the source table changes. But it's more than that. One neat thing is that it can handle incremental aggregations, such as AVG, SUM, and Percentiles, which would not be doable just with insert triggers. ClickHouse can do this because it stores the intermediate state of the aggregations in special Aggregate Function data types.