skip to main content
Supported SQL Functionality and Extensions : SQL Expressions : Character operator
  

Try DataDirect Drivers Now

Character operator

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