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
    ]
  }
}