| --- |
| { |
| "title": "ARRAY_SUM", |
| "language": "en" |
| } |
| --- |
| |
| ## array_sum |
| array_sum |
| |
| ### description |
| |
| #### Syntax |
| |
| ```sql |
| T array_sum(ARRAY<T> src, Array<T> key) |
| T array_sum(lambda, Array<T> arr1, Array<T> arr2 ....) |
| ``` |
| |
| Get the sum of all elements in an array (`NULL` values are skipped). |
| When the array is empty or all elements in the array are `NULL` values, the function returns `NULL`. |
| |
| ### example |
| |
| ```shell |
| mysql> create table array_type_table(k1 INT, k2 Array<int>) duplicate key (k1) |
| -> distributed by hash(k1) buckets 1 properties('replication_num' = '1'); |
| mysql> insert into array_type_table values (0, []), (1, [NULL]), (2, [1, 2, 3]), (3, [1, NULL, 3]); |
| mysql> select k2, array_sum(k2) from array_type_table; |
| +--------------+-----------------+ |
| | k2 | array_sum(`k2`) | |
| +--------------+-----------------+ |
| | [] | NULL | |
| | [NULL] | NULL | |
| | [1, 2, 3] | 6 | |
| | [1, NULL, 3] | 4 | |
| +--------------+-----------------+ |
| 4 rows in set (0.01 sec) |
| |
| ``` |
| |
| ### keywords |
| |
| ARRAY,SUM,ARRAY_SUM |
| |
