Interface WindowFrameBuilder<T>

  • Type Parameters:
    T - The builder return type

    public interface WindowFrameBuilder<T>
    An interface for building a window frame clause for analytics functions.
    Since:
    1.4.0
    Author:
    Christian Beikov
    • Method Detail

      • betweenUnboundedPreceding

        WindowFrameBetweenBuilder<T> betweenUnboundedPreceding()
        Uses UNBOUNDED PRECEDING as lower bound for the frame and starts a frame between builder for the upper bound.
        Returns:
        The frame between builder
      • betweenPreceding

        WindowFrameBetweenBuilder<T> betweenPreceding​(String expression)
        Uses expression PRECEDING as lower bound for the frame and starts a frame between builder for the upper bound.
        Parameters:
        expression - The expression for the frame bound
        Returns:
        The frame between builder
      • betweenFollowing

        WindowFrameBetweenBuilder<T> betweenFollowing​(String expression)
        Uses expression FOLLOWING as lower bound for the frame and starts a frame between builder for the upper bound.
        Parameters:
        expression - The expression for the frame bound
        Returns:
        The frame between builder
      • betweenCurrentRow

        WindowFrameBetweenBuilder<T> betweenCurrentRow()
        Uses CURRENT ROW as lower bound for the frame and starts a frame between builder for the upper bound.
        Returns:
        The frame between builder
      • unboundedPreceding

        WindowFrameExclusionBuilder<T> unboundedPreceding()
        Uses UNBOUNDED PRECEDING as lower bound and continues to the frame exclusion builder.
        Returns:
        The frame exclusion builder
      • preceding

        WindowFrameExclusionBuilder<T> preceding​(String expression)
        Uses X PRECEDING as lower bound and continues to the frame exclusion builder.
        Parameters:
        expression - The expression for the frame bound
        Returns:
        The frame exclusion builder
      • currentRow

        WindowFrameExclusionBuilder<T> currentRow()
        Uses CURRENT ROW as lower bound and continues to the frame exclusion builder.
        Returns:
        The frame exclusion builder