Get started
Load & manage data
Work with data
Administration
Reference & resources
CLUSTER BY
mask
ROW FILTER
Atualizado 06/12/2024
Send us feedback
array_append
Applies to: Databricks SQL Databricks Runtime 12.2 LTS and above
Returns array appended by elem.
array
elem
array_append(array, elem)
array: An ARRAY.
elem: An expression of the same type as the elements of array.
An ARRAY of the same type as array.
> SELECT array_append(array(1, 2, 3), 0); [1,2,3,0] > SELECT array_append(array(1, 2, 3), NULL); [1,2,3,NULL]
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