array_to_string(array: array, sep: string) -> string

Cast all values in an array to string and concatenate them, optionally adding a separator between each value.

A null argument returns a null result. An array containing any null values returns a null result.

Domain

This is a scalar function (calculates a single output value for a single input row).

Categories

• Semistructured
• String

Examples

Filter all rows whose numbers column (an array of integers) contains a total number of digits greater than 17.

Make the column 'messages' by concatenating object array field messages values, separated by the - character.

Filter all rows whose numbers column (an array of integers) contains a total number of digits greater than 17, checking if the array_to_string resulted in a null value and replacing that with the empty string.