Get started
Load & manage data
Work with data
Administration
Reference & resources
CLUSTER BY
mask
ROW FILTER
Updated Nov 01, 2024
Send us feedback
array_prepend
Applies to: Databricks SQL Databricks Runtime 13.3 LTS and above
Returns array prepended by elem.
array
elem
array_prepend(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_prepend(array(1, 2, 3), 0); [0,1,2,3] > SELECT array_prepend(array(1, 2, 3), NULL); [NULL,1,2,3]
array_append function
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