BOTTOMK
This page describes the BOTTOMK function in Lenses SQL.
BOTTOMK(numExpr, N)
Returns the last K lowest ranked values. The ranking is based on how many times a value has been seen.
Available in:
Processor (stateless)
Processors (stateful)
SQL Studio
✓
Sample code:
USE `kafka`;
SELECT BOTTOMK(total)
FROM orders-events
Output:
{
"value": {
"BOTTOMK": [
10.14
]
}
}
Last updated
Was this helpful?