1 of 1

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": "Jose.Hood@aol.com"
  }
}