ARRAY_SUM

Description

Calculates the sum of all elements in an array

Syntax

ARRAY_SUM(<src>)

Parameters

Parameter	Description
<src>	Corresponding array

Return Value

Returns the sum of all elements in the array. NULL values in the array will be skipped. For an empty array or an array with all NULL values, the result returns a NULL value.

Example

SELECT ARRAY_SUM([1, 2, 3, 6]),ARRAY_SUM([1, 4, 3, 5, NULL]),ARRAY_SUM([NULL]);

+-------------------------+-------------------------------+-------------------------------------------+
| array_sum([1, 2, 3, 6]) | array_sum([1, 4, 3, 5, NULL]) | array_sum(cast([NULL] as ARRAY<BOOLEAN>)) |
+-------------------------+-------------------------------+-------------------------------------------+
|                      12 |                            13 |                                      NULL |
+-------------------------+-------------------------------+-------------------------------------------+