This section contains reference documentation for the concat function.
Concatenate two input strings using the seperator
CONCAT(col1, col2, seperator)
SELECT concat('Apache', 'Pinot', ' ') AS value FROM ignoreMe
SELECT concat('real-time', 'analytics', '__') AS value FROM ignoreMe
Apache Pinot
real-time__analytics