DROPLEFT
This page describes the DROPLEFT function in Lenses SQL.
DROPLEFT(expr, lengthExpr)
Removes the left most ’length’ characters from a string expression.
Available in:
Sample code:
USE `kafka`;
SELECT
DROPLEFT(password_hash, 50),
password_hash
FROM users-topic
LIMIT 1;
Output:
{
"value": {
"DROPLEFT": "872fd17f01f428",
"password_hash": "cc53c3b3b0b966804573ceb917390510de95742d7caf3d7474872fd17f01f428"
}
}