Interface JpaWindow

  • All Known Implementing Classes:
    SqmWindow

    @Incubating
    public interface JpaWindow
    Common contract for window parts used in window and aggregate functions.
    • Method Detail

      • partitionBy

        JpaWindow partitionBy​(Expression<?>... expressions)
        Add partition by expressions to the window.
        Parameters:
        expressions - the partition by expressions
        Returns:
        the modified window
      • orderBy

        JpaWindow orderBy​(Order... expressions)
        Add order by expressions to the window.
        Parameters:
        expressions - the order by expressions
        Returns:
        the modified window
      • frameRows

        JpaWindow frameRows​(JpaWindowFrame startFrame,
                            JpaWindowFrame endFrame)
        Add a ROWS frame clause to the window and define start and end JpaWindowFrame specifications.
        Parameters:
        startFrame - the start frame
        endFrame - the optional end frame
        Returns:
        the modified window
      • frameRange

        JpaWindow frameRange​(JpaWindowFrame startFrame,
                             JpaWindowFrame endFrame)
        Add a RANGE frame clause to the window and define start and end JpaWindowFrame specifications.
        Parameters:
        startFrame - the start frame
        endFrame - the optional end frame
        Returns:
        the modified window
      • frameGroups

        JpaWindow frameGroups​(JpaWindowFrame startFrame,
                              JpaWindowFrame endFrame)
        Add a GROUPS frame clause to the window and define start and end JpaWindowFrame specifications.
        Parameters:
        startFrame - the start frame
        endFrame - the optional end frame
        Returns:
        the modified window
      • frameExclude

        JpaWindow frameExclude​(FrameExclusion frameExclusion)
        Set a FrameExclusion for this window's frame.
        Parameters:
        frameExclusion - the frame exclusion
        Returns:
        the modified window