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
Related functions
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for