v.23.10New Feature

Added lttb Aggregation Function for Data Downsampling

Official CH changelog text
Added aggregation function lttb which uses the Largest-Triangle-Three-Buckets algorithm for downsampling data for visualization. #53145 (Sinan).
Added a new aggregation function lttb that implements the Largest-Triangle-Three-Buckets algorithm for efficient downsampling of data for visualization purposes.

Why it matters

This feature addresses the need to reduce large datasets into representative smaller samples while preserving the visual characteristics of the data. It helps users create clearer and more meaningful visualizations by minimizing data points without significant loss of information.

How to use it

Use the lttb aggregation function in your SELECT queries to downsample time-series or sequential data for plotting. For example:

SELECT
    some_key,
    lttb(value, timestamp) AS downsampled_value
FROM
    table
GROUP BY
    some_key

Related resources

PreviousNext