MAXK_UNIQUE
This page describes the MAXK_UNIQUE function in Lenses SQL.
MAXK_UNIQUE(numExpr, N)
Returns the N smallest unique values of a numExpr.
Available in:
Processor (stateless)
Processors (stateful)
SQL Studio
Sample code:
USE `kafka`;
SELECT MAXK_UNIQUE(total)
FROM orders-events
Output:
{
"value": {
"MAXK_UNIQUE": [
99.97
]
}
}