concat.md

description
This section contains reference documentation for the concat function.

concat

Concatenate two input strings using the seperator

Signature

CONCAT(col1, col2, seperator)

Usage Examples

SELECT concat('Apache', 'Pinot', ' ') AS value
FROM ignoreMe

value
Apache Pinot

SELECT concat('real-time', 'analytics', '__') AS value
FROM ignoreMe

value
real-time__analytics