Window

Functions that perform calculations across rows of the query result.

Todo

Support for window functions is experimental and unlikely to be supported by the existing parsers.

These function needs to be wrapped as a valid dsl.Feature using the dsl.Window API.

Aggregate Functions

All Aggregate functions can be used as window functions by calling the .over() method.

Ranking Functions

class forml.io.dsl.function.RowNumber[source]

A unique sequential number for each row starting from one according to the ordering of rows within the window partition.

Examples

>>> ETL = Student.select(function.RowNumber().over(Student.surname))