Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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
Examples
> SELECT concat('Spark', 'SQL');
SparkSQL
> SELECT concat(array(1, 2, 3), array(4, 5), array(6));
[1,2,3,4,5,6]