Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 ofarray
.
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]