1 of 1

TRUNCATE

This page describes the TRUNCATE function in Lenses SQL.

TRUNCATE(strExpr, nExpr)

Truncates a string so that it has at most N characters.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT 
    `TRUNCATE`(first_name, 2), 
    first_name 
FROM users-topic
LIMIT 1;

Output:

{
  "value": {
    "TRUNCATE": "Jo",
    "first_name": "Jose"
  }
}

This page describes the TRUNCATE function in Lenses SQL.

TRUNCATE(strExpr, nExpr)

Truncates a string so that it has at most N characters.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT 
    `TRUNCATE`(first_name, 2), 
    first_name 
FROM users-topic
LIMIT 1;

Output:

{
  "value": {
    "TRUNCATE": "Jo",
    "first_name": "Jose"
  }
}