ARR_PRODUCT
Syntax
ARR_PRODUCT( array )Description
Returns the product of elements in the array.
Argument types:
array—Array of fractional numbers | Array of integers
Return type: Fractional number
Note
This function cannot work with arrays with Nullable items. To remove NULL items from the array, use ARR_REMOVE or REPLACE.
Example
| [int_array] | [float_array] | ARR_PRODUCT([int_array]) | ARR_PRODUCT([float_array]) |
|---|---|---|---|
'[21,12,0]' | '[14.3,0.42,15]' | 0.00 | 90.09 |
'[-4,12,0]' | '[0,-3,12]' | 0.00 | -0.00 |
'[5,7,9]' | '[3.2,2.3,3.2]' | 315.00 | 23.55 |
Data source support
ClickHouse 21.8.
Previous
Next