concat function

Applies to: Databricks SQL Databricks Runtime

Returns the concatenation of the arguments. This function is a synonym for || (pipe pipe sign) operator.

Syntax

concat(expr1, expr2 [, ...] )

Arguments

• exprN: Expressions which are all STRING, all BINARY or all ARRAYs of STRING or BINARY.

Returns

The result type matches the argument types.

There must be at least one argument.

When concatenating arrays, Azure Databricks raises COLLECTION_SIZE_LIMIT_EXCEEDED if the result exceeds the array size limit.

Common error conditions

• COLLECTION_SIZE_LIMIT_EXCEEDED

Examples

> SELECT concat('Spark', 'SQL');
 SparkSQL
> SELECT concat(array(1, 2, 3), array(4, 5), array(6));
 [1,2,3,4,5,6]

Related functions

• || (pipe pipe sign) operator
• array_join function
• array_union function
• concat_ws function