The concatenation operator (||) is not supported. However, the CONCAT function is supported by Apache Spark SQL. For example, the following statement is supported:

SELECT CONCAT('Name is', ’(ename FROM emp)’)