array_join
function
Applies to: Databricks SQL Databricks Runtime
Concatenates the elements of array
.
Syntax
array_join(array, delimiter [, nullReplacement])
Arguments
array
: AnyARRAY
type, but its elements are interpreted as strings.delimiter
: ASTRING
used to separate the concatenated array elements.nullReplacement
: ASTRING
used to express aNULL
value in the result.
Returns
A STRING
where the elements of array
are separated by delimiter
and null elements are substituted for nullReplacement
.
If nullReplacement
is omitted, null elements are filtered out.
If any argument is NULL
, the result is NULL
.
Examples
> SELECT array_join(array('hello', 'world'), ',');
hello,world
> SELECT array_join(array('hello', NULL ,'world'), ',');
hello,world
> SELECT array_join(array('hello', NULL ,'world'), ',', '*');
hello,*,world