Function first

  • first(column: string): Column

    Aggregate function: returns the first value in a group.

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

    Parameters

    • column: string

    Returns Column

    Note

    The function is non-deterministic because its results depends on the order of the rows which may be non-deterministic after a shuffle.

  • first(column: Column): Column

    Aggregate function: returns the first value in a group.

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

    Parameters

    Returns Column

    Note

    The function is non-deterministic because its results depends on the order of the rows which may be non-deterministic after a shuffle.

  • first(column: string, ignoreNulls: boolean): Column

    Aggregate function: returns the first value in a group.

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

    Parameters

    • column: string
    • ignoreNulls: boolean

    Returns Column

    Note

    The function is non-deterministic because its results depends on the order of the rows which may be non-deterministic after a shuffle.

  • first(column: Column, ignoreNulls: boolean): Column

    Aggregate function: returns the first value in a group.

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

    Parameters

    • column: Column
    • ignoreNulls: boolean

    Returns Column

    Note

    The function is non-deterministic because its results depends on the order of the rows which may be non-deterministic after a shuffle.

Settings

Member Visibility