Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Won't Fix
    • 3.1.0
    • None
    • SQL
    • None

    Description

       

       

      select last(salary) over(order by salary range between 1000 preceding and 1000 following),
      lag(salary) over(order by salary range between 1000 preceding and 1000 following),
      salary from empsalary
      org.apache.spark.sql.AnalysisException
      Window Frame specifiedwindowframe(RangeFrame, -1000, 1000) must match the required frame specifiedwindowframe(RowFrame, -1, -1);
      

       

      Maybe we need to fix this issue.

      Attachments

        Activity

          beliefer Jiaan Geng added a comment -

          The fact is each mainstream database don't support specify window frame for LEAD/LAG.
          https://issues.apache.org/jira/browse/SPARK-33125 improved the error message.
          Let me close this ticket.

          beliefer Jiaan Geng added a comment - The fact is each mainstream database don't support specify window frame for LEAD/LAG. https://issues.apache.org/jira/browse/SPARK-33125 improved the error message. Let me close this ticket.

          People

            Unassigned Unassigned
            beliefer Jiaan Geng
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: