SQL reference

Window functions

OVER clauses, frames and the windowed aggregates a SELECT can carry.

Note

In preparation

This page has its place in the documentation and is being written. The SQL reference index lists the pages of the section that are ready.

Joins

Joins in one-shot SELECT, in streaming queries and in transformations — INNER, LEFT, RIGHT, FULL, CROSS, ASOF LEFT and LOOKUP.

STREAM SELECT

Grammar of continuous queries — relations, joins and TUMBLE, HOP or SESSION windows, filters, aggregates, ordering and EMIT.