Character Operator The concatenation operator (||) is not supported; however, the CONCAT function is supported by Impala SQL. SELECT CONCAT('Name is', ’(ename FROM emp)’)