Skip to main content
Last updated on

concat function

Applies to: check marked yes Databricks SQL check marked yes 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, Databricks raises COLLECTION_SIZE_LIMIT_EXCEEDED if the result exceeds the array size limit.

Common error conditions​

Examples​

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