Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
A window specification that defines the partitioning, ordering, and frame boundaries.
Changed in Databricks Runtime 13.0: Supports Spark Connect.
Use the static methods in Window to create a WindowSpec.
Methods
| Method | Description |
|---|---|
orderBy(*cols) |
Defines the ordering columns in a WindowSpec. |
partitionBy(*cols) |
Defines the partitioning columns in a WindowSpec. |
rangeBetween(start, end) |
Defines the frame boundaries, from start (inclusive) to end (inclusive), using range-based offsets from the current row's ORDER BY value. |
rowsBetween(start, end) |
Defines the frame boundaries, from start (inclusive) to end (inclusive), using row-based offsets from the current row. |