MINK

This page describes the MINK function in Lenses SQL.

MINK(numExpr, N)

Returns the N smallest values of an numExpr.

Available in:

Processor (stateless)	Processors (stateful)	SQL Studio
✓

Sample code:

USE `kafka`;
SELECT MINK(total) 
FROM orders-events

Output:

{
  "value": {
    "MINK": [
      10.14
    ]
  }
}