Sidebar

HPL/SQL is included to Apache Hive since version 2.0

concat

CONCAT Function - PL/HQL Reference

CONCAT function concatenates two or more strings.

Syntax:

CONCAT(expr, expr2 [, expr3, ...]); 

Notes:

  • If an expression evaluates to NULL it is treated as an empty string
  • CONCAT returns NULL only if all expressions evaluate to NULL

Return Type:

STRING

Example:

CONCAT('a', 'b', NULL, 'c'); 

Result: abc

Compatibility: Oracle, IBM DB2, Teradata, Microsoft SQL Server, PostgreSQL, MySQL and Netezza

Version: PL/HQL 0.3.1

See also: