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

Buffer in SlidingWindowFunctionFrame could be big though window is small

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 2.1.1
    • 2.2.1, 2.3.0
    • SQL
    • 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

            jinxing6042@126.com Jin Xing
            jinxing6042@126.com Jin Xing
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: