LEN

This page describes the LEN function in Lenses SQL.

LEN expr

Returns the length of a string. Calculates length using characters as defined by UTF-16.

Available in:

Processors	SQL Studio
✓	✓

Sample code:

USE `kafka`;
SELECT 
    LEN(email), 
    email 
FROM users-topic
LIMIT 1;

Output:

{
  "value": {
    "LEN": 17,
    "email": "[e-mail]"
  }
}