Aggregate

This section describes how to use AGGREGATE functions in Lenses SQL.

Loading...

BOTTOMK

This page describes the BOTTOMK function in Lenses SQL.

Returns the last K lowest ranked values. The ranking is based on how many times a value has been seen.

Available in:

Sample code:

Output:

This page describe the COLLECT function in Lenses SQL.

COLLECT(expr, maxN)

Returns an array in which each value in the input set is assigned to an element of the array.

Available in:

Processor (stateless)

Processors (stateful)

SQL Studio

✓

Sample code:

USE `kafka`;
SELECT COLLECT(total, 5) 
FROM orders-events

Output:

{
  "value": {
    "COLLECT": [
      43.63,
      16.93,
      80.47,
      56.86,
      29.12
    ]
  }
}

Loading...