You are viewing documentation about an older version (1.12.1). View latest version

Window

Classes

Window()

Contains functions to form WindowSpec.

Methods

Window.orderBy(*cols)

Returns a WindowSpec object with order by clause.

Window.order_by(*cols)

Returns a WindowSpec object with order by clause.

Window.partitionBy(*cols)

Returns a WindowSpec object with partition by clause.

Window.partition_by(*cols)

Returns a WindowSpec object with partition by clause.

Window.rangeBetween(start, end)

Returns a WindowSpec object with the range frame clause.

Window.range_between(start, end)

Returns a WindowSpec object with the range frame clause.

Window.rowsBetween(start, end)

Returns a WindowSpec object with the row frame clause.

Window.rows_between(start, end)

Returns a WindowSpec object with the row frame clause.

WindowSpec.orderBy(*cols)

Returns a new WindowSpec object with the new order by clause.

WindowSpec.order_by(*cols)

Returns a new WindowSpec object with the new order by clause.

WindowSpec.partitionBy(*cols)

Returns a new WindowSpec object with the new partition by clause.

WindowSpec.partition_by(*cols)

Returns a new WindowSpec object with the new partition by clause.

WindowSpec.rangeBetween(start, end)

Returns a new WindowSpec object with the new range frame clause.

WindowSpec.range_between(start, end)

Returns a new WindowSpec object with the new range frame clause.

WindowSpec.rowsBetween(start, end)

Returns a new WindowSpec object with the new row frame clause.

WindowSpec.rows_between(start, end)

Returns a new WindowSpec object with the new row frame clause.

Attributes

Window.CURRENT_ROW

Returns a value representing current row.

Window.UNBOUNDED_FOLLOWING

Returns a value representing unbounded following.

Window.UNBOUNDED_PRECEDING

Returns a value representing unbounded preceding.

Window.currentRow

Window.unboundedFollowing

Window.unboundedPreceding