v.20.4New Feature
Add arrayAUC function
Add function arrayAUC #8698 (taiyang-li)Why it matters
ThearrayAUC 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 thearrayAUC 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.