Functions.Last Method

Definition

Namespace:

Microsoft.Spark.Sql

Assembly:

Microsoft.Spark.dll

Package:

Microsoft.Spark v1.0.0

Overloads

Last(Column, Boolean)	Returns the last value of a column in a group.
Last(String, Boolean)	Returns the last value of a column in a group.

Last(Column, Boolean)

Returns the last value of a column in a group.

public static Microsoft.Spark.Sql.Column Last (Microsoft.Spark.Sql.Column column, bool ignoreNulls = false);

static member Last : Microsoft.Spark.Sql.Column * bool -> Microsoft.Spark.Sql.Column

Public Shared Function Last (column As Column, Optional ignoreNulls As Boolean = false) As Column

Parameters

column

Column

Column to apply

ignoreNulls

Boolean

To ignore null or not

Returns

Column

Column object

Remarks

The function by default returns the last values it sees. It will return the last non-null value it sees when ignoreNulls is set to true. If all values are null, then null is returned.

Last(String, Boolean)

Returns the last value of a column in a group.

public static Microsoft.Spark.Sql.Column Last (string columnName, bool ignoreNulls = false);

static member Last : string * bool -> Microsoft.Spark.Sql.Column

Public Shared Function Last (columnName As String, Optional ignoreNulls As Boolean = false) As Column

Parameters

columnName

String

Column name

ignoreNulls

Boolean

To ignore null or not

Returns

Column

Column object

Remarks

The function by default returns the last values it sees. It will return the last non-null value it sees when ignoreNulls is set to true. If all values are null, then null is returned.