Details
-
Sub-task
-
Status: Resolved
-
Major
-
Resolution: Won't Fix
-
3.1.0
-
None
-
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.
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.