Window Class

Definition

Namespace:

Microsoft.Spark.Sql.Expressions

Assembly:

Microsoft.Spark.dll

Package:

Microsoft.Spark v1.0.0

Utility functions for defining window in DataFrames.

public static class Window

type Window = class

Public Class Window

Inheritance

Object

Window

Properties

CurrentRow	Value representing the current row.
UnboundedFollowing	Value representing the last row in the partition, equivalent to "UNBOUNDED FOLLOWING" in SQL.
UnboundedPreceding	Value representing the first row in the partition, equivalent to "UNBOUNDED PRECEDING" in SQL.

Methods

OrderBy(Column[])	Creates a WindowSpec with the ordering defined.
OrderBy(String, String[])	Creates a WindowSpec with the ordering defined.
PartitionBy(Column[])	Creates a WindowSpec with the partitioning defined.
PartitionBy(String, String[])	Creates a WindowSpec with the partitioning defined.
RangeBetween(Column, Column)	Creates a WindowSpec with the frame boundaries defined, from start (inclusive) to end (inclusive).
RangeBetween(Int64, Int64)	Creates a WindowSpec with the frame boundaries defined, from start (inclusive) to end (inclusive).
RowsBetween(Int64, Int64)	Creates a WindowSpec with the frame boundaries defined, from start (inclusive) to end (inclusive).