||
(pipe pipe sign) operator
Applies to: Databricks SQL Databricks Runtime
Returns the concatenation of expr1
and expr2
. This operator is a synonym for concat function.
CLUSTER BY
clause (TABLE)mask
clauseROW FILTER
clauseUpdated Nov 01, 2024
||
(pipe pipe sign) operator||
(pipe pipe sign) operator Applies to: Databricks SQL Databricks Runtime
Returns the concatenation of expr1
and expr2
. This operator is a synonym for concat function.
expr1
: A STRING, BINARY or ARRAY of STRING or BINARY expression.
expr2
: An expression with type matching expr1
.
> SELECT 'Spark' || 'SQL';
SparkSQL
> SELECT array(1, 2, 3) || array(4, 5) || array(6);
[1,2,3,4,5,6]