ABBREVIATE

This page describes the ABBREVIATE function in Lenses SQL.

ABBREVIATE(expr, lengthExpr)

Abbreviates the expression to the given length and appends ellipses.

Available in:

Processors	SQL Studio
✓	✓

Sample code:

USE `kafka`;
SELECT 
    ABBREVIATE(password_hash, 10), 
    password_hash 
FROM users-topic
LIMIT 1;

Output:

{
  "value": {
    "ABBREVIATE": "cc53c3b...",
    "password_hash": "cc53c3b3b0b966804573ceb917390510de95742d7caf3d7474872fd17f01f428"
  }
}