v.18.1New Feature

SummingMergeTree Engine Supports AggregateFunction Type Columns

Official CH changelog text
The SummingMergeTree engine can now work with AggregateFunction type columns (Constantin S. Pan).
The SummingMergeTree table engine now supports columns of type AggregateFunction, enabling efficient aggregation of pre-aggregated data.

Why it matters

This feature allows users to store and merge data with AggregateFunction columns directly within the SummingMergeTree engine, solving the problem of handling complex aggregate states more seamlessly and improving data aggregation workflows.

How to use it

Define a table using the SummingMergeTree engine with one or more columns of type AggregateFunction. The engine will automatically merge these aggregate states during data merges and queries.

Related resources

PreviousNext