Interface WindowBuilder<T>

  • Type Parameters:
    T - The builder return type
    All Superinterfaces:
    OrderByBuilder<WindowBuilder<T>>

    public interface WindowBuilder<T>
    extends OrderByBuilder<WindowBuilder<T>>
    An interface for building a window for analytics functions.
    Since:
    1.4.0
    Author:
    Christian Beikov
    • Method Detail

      • filter

        <X extends WhereBuilder<X> & WindowBuilder<X>> X filter()
        Starts a filter builder.
        Type Parameters:
        X - The filter builder type
        Returns:
        The filter builder
      • partitionBy

        WindowBuilder<T> partitionBy​(String... partitionExpressions)
        Adds a partition by clause with the given expressions to the window.
        Parameters:
        partitionExpressions - The expressions for the partition by clause
        Returns:
        The window builder for chaining calls
      • partitionBy

        WindowBuilder<T> partitionBy​(String partitionExpression)
        Adds a partition by clause with the given expression to the window.
        Parameters:
        partitionExpression - The expression for the partition by clause
        Returns:
        The window builder for chaining calls
      • rows

        WindowFrameBuilder<T> rows()
        Starts a frame builder with the ROWS frame mode.
        Returns:
        The frame builder
      • range

        WindowFrameBuilder<T> range()
        Starts a frame builder with the RANGE frame mode.
        Returns:
        The frame builder
      • groups

        WindowFrameBuilder<T> groups()
        Starts a frame builder with the GROUPS frame mode.
        Returns:
        The frame builder
      • end

        T end()
        Finishes the window builder.
        Returns:
        The parent query builder