array_append function

Applies to: Databricks SQL Databricks Runtime 12.2 LTS and above

Returns array appended by elem.

Syntax

array_append(array, elem)

Arguments

• array: An ARRAY.

• elem: An expression of the same type as the elements of array.

Returns

An ARRAY of the same type as array.

Examples

> SELECT array_append(array(1, 2, 3), 0);
 [1,2,3,0]

> SELECT array_append(array(1, 2, 3), NULL);
 [1,2,3,NULL]

Related functions

• array_compact function

• array_distinct function

• array_except function

• array_insert function

• array_intersect function

• array_remove function

• array_sort function

• array_union function

• zip_with function