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

FramelessOffsetWindowFunctionFrame fails when ignore nulls and offset > # of rows

    XMLWordPrintableJSON

Details

    Description

      Failure when function that utilized `FramelessOffsetWindowFunctionFrame` is used with `ignoreNulls = true` and `offset > rowCount`.

      e.g.

      ```
      select x, lead(x, 5) IGNORE NULLS over (order by x) from (select explode(sequence(1, 3)) x)
      ```

      Attachments

        Issue Links

          Activity

            People

              vli-databricks Vitalii Li
              vli-databricks Vitalii Li
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: