Window.RangeBetween Method

Definition

Namespace:

Microsoft.Spark.Sql.Expressions

Assembly:

Microsoft.Spark.dll

Package:

Microsoft.Spark v1.0.0

Overloads

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).

RangeBetween(Column, Column)

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

[Microsoft.Spark.Deprecated("2.4.0")]
[Microsoft.Spark.Removed("3.0.0")]
public static Microsoft.Spark.Sql.Expressions.WindowSpec RangeBetween (Microsoft.Spark.Sql.Column start, Microsoft.Spark.Sql.Column end);

[<Microsoft.Spark.Deprecated("2.4.0")>]
[<Microsoft.Spark.Removed("3.0.0")>]
static member RangeBetween : Microsoft.Spark.Sql.Column * Microsoft.Spark.Sql.Column -> Microsoft.Spark.Sql.Expressions.WindowSpec

Public Shared Function RangeBetween (start As Column, end As Column) As WindowSpec

Parameters

start

Column

Boundary start, inclusive. The frame is unbounded if the expression is Microsoft.Spark.Sql.Functions.UnboundedPreceding()

end

Column

Boundary end, inclusive. The frame is unbounded if the expression is Microsoft.Spark.Sql.Functions.UnboundedFollowing()

Returns

WindowSpec

WindowSpec object

Attributes

DeprecatedAttribute RemovedAttribute

Remarks

This API is deprecated in Spark 2.4 and removed in Spark 3.0.

RangeBetween(Int64, Int64)

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

public static Microsoft.Spark.Sql.Expressions.WindowSpec RangeBetween (long start, long end);

static member RangeBetween : int64 * int64 -> Microsoft.Spark.Sql.Expressions.WindowSpec

Public Shared Function RangeBetween (start As Long, end As Long) As WindowSpec

Parameters

start

Int64

Boundary start, inclusive. The frame is unbounded if this is the minimum long value Window.s_unboundedPreceding.

end

Int64

Boundary end, inclusive. The frame is unbounded if this is maximum long value Window.s_unboundedFollowing.

Returns

WindowSpec

WindowSpec object