Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-21414

Buffer in SlidingWindowFunctionFrame could be big though window is small

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.1.1
    • Fix Version/s: 2.2.1, 2.3.0
    • Component/s: SQL
    • Labels:
      None

      Description

      In SlidingWindowFunctionFrame, it is now adding all rows to the buffer for which the input row value is equal to or less than the output row upper bound, then drop all rows from the buffer for which the input row value is smaller than the output row lower bound.
      This could result in the buffer is very big though the window is small.

      For example:
      select a, b, sum(a) over (partition by b order by a range between 1000000 following and 1000001 following) from table

        Attachments

          Activity

            People

            • Assignee:
              jinxing6042@126.com jin xing
              Reporter:
              jinxing6042@126.com jin xing
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: