array_sum

SinceVersion 1.2.0

array_sum

description

Syntax

1. T array_sum(ARRAY<T> src, Array<T> key)
2. T array_sum(lambda, Array<T> arr1, Array<T> arr2 ....)

返回数组中所有元素之和，数组中的NULL值会被跳过。空数组以及元素全为NULL值的数组，结果返回NULL值。

example

1. mysql> create table array_type_table(k1 INT, k2 Array<int>) duplicate key (k1)
2. -> distributed by hash(k1) buckets 1 properties('replication_num' = '1');
3. mysql> insert into array_type_table values (0, []), (1, [NULL]), (2, [1, 2, 3]), (3, [1, NULL, 3]);
4. mysql> set enable_vectorized_engine = true;    # enable vectorized engine
5. mysql> select k2, array_sum(k2) from array_type_table;
6. +--------------+-----------------+
7. | k2           | array_sum(`k2`) |
8. +--------------+-----------------+
9. | []           |            NULL |
10. | [NULL]       |            NULL |
11. | [1, 2, 3]    |               6 |
12. | [1, NULL, 3] |               4 |
13. +--------------+-----------------+
14. 4 rows in set (0.01 sec)

keywords

ARRAY,SUM,ARRAY_SUM