v.20.4New Feature

Add arrayAUC function

Add function arrayAUC #8698 (taiyang-li)
Introduces the new function arrayAUC to ClickHouse for calculating the Area Under the Curve (AUC) of an array of data points.

Why it matters

The arrayAUC function provides a simple and efficient way to compute the integral or area under a curve represented by an array of numeric values. This is useful in scenarios involving signal processing, performance evaluation, and other analytical tasks where understanding the total magnitude encapsulated by sequential data points is required.

How to use it

Users can apply the arrayAUC function directly in their SQL queries by passing an array of numeric values as the argument, for example:
SELECT arrayAUC([1, 2, 3, 4])
. No additional configuration is needed to enable this function.