array_prepend function

Applies to: Databricks SQL Databricks Runtime 13.3 LTS and above

Returns array prepended by elem.

Syntax

array_prepend(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

SQL

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

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

Related functions

• 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