v.23.5New Feature

Function dotProduct for array functionality improvement

Official CH changelog text
Function dotProduct work for array. #49050 (FFFFFFFHHHHHHH).
Added support for the dotProduct function to operate on Array types in ClickHouse.

Why it matters

This feature enables users to calculate the dot product directly between array values, simplifying mathematical and vector operations on array data without needing explicit unnesting or additional transformations.

How to use it

Use the dotProduct function by passing two arrays as arguments in your query, for example: SELECT dotProduct(arr1, arr2) FROM table. The function will compute the dot product of the two arrays element-wise.

Related resources

PreviousNext