CONCAT

This page describes the CONCAT function in Lenses SQL.

CONCAT(expr1, expr2, expr3)

Returns the string representation of concatenating each expression in the list. Null fields are left out.

Available in:

Processors	SQL Studio
✓	✓

Sample code:

USE `kafka`;
SELECT 
    CONCAT(first_name,' ', last_name),
    first_name, 
    last_name 
FROM users-topic
LIMIT 1;

Output:

{
  "value": {
    "CONCAT": "Jose Hood",
    "first_name": "Jose",
    "last_name": "Hood"
  }
}