Window

Window.currentRow

Window.orderBy(*cols)

Creates a WindowSpec with the ordering defined.

Window.partitionBy(*cols)

Creates a WindowSpec with the partitioning defined.

Window.rangeBetween(start, end)

Creates a WindowSpec with the frame boundaries defined, from start (inclusive) to end (inclusive).

Window.rowsBetween(start, end)

Creates a WindowSpec with the frame boundaries defined, from start (inclusive) to end (inclusive).

Window.unboundedFollowing

Window.unboundedPreceding

WindowSpec.orderBy(*cols)

Defines the ordering columns in a WindowSpec.

WindowSpec.partitionBy(*cols)

Defines the partitioning columns in a WindowSpec.

WindowSpec.rangeBetween(start, end)

Defines the frame boundaries, from start (inclusive) to end (inclusive).

WindowSpec.rowsBetween(start, end)

Defines the frame boundaries, from start (inclusive) to end (inclusive).