Package com.snowflake.snowpark_java

Class Window

  • public final class Window
extends Object
    Contains functions to form WindowSpec.
    Since:
    0.9.0

    • Method Detail

      • partitionBy

        public static WindowSpec partitionBy​(Column... cols)
        Returns WindowSpec object with partition by clause.
        Parameters:
        cols - The list of column
        Returns:
        The result WindowSpec
        Since:
        0.9.0

      • orderBy

        public static WindowSpec orderBy​(Column... cols)
        Returns WindowSpec object with order by clause.
        Parameters:
        cols - The list of column
        Returns:
        The result WindowSpec
        Since:
        0.9.0

      • unboundedPreceding

        public static long unboundedPreceding()
        Returns a value representing unbounded preceding.
        Returns:
        A long value
        Since:
        0.9.0

      • unboundedFollowing

        public static long unboundedFollowing()
        Returns a value representing unbounded following.
        Returns:
        A long value
        Since:
        0.9.0

      • currentRow

        public static long currentRow()
        Returns a value representing current row.
        Returns:
        A long value
        Since:
        0.9.0

      • rowsBetween

        public static WindowSpec rowsBetween​(long start,
                                     long end)
        Returns WindowSpec object with row frame clause.
        Parameters:
        start - The start position
        end - The end position
        Returns:
        The result WindowSpec
        Since:
        0.9.0

      • rangeBetween

        public static WindowSpec rangeBetween​(long start,
                                      long end)
        Returns WindowSpec object with range frame clause.
        Parameters:
        start - The start position
        end - The end position
        Returns:
        The result WindowSpec
        Since:
        0.9.0