[SPARK-30734] AnalysisException that window RangeFrame not match RowFrame

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 3.1.0
• Component/s: SQL
• Assignee: Unassigned Assign to me
• Reporter: Jiaan Geng
• Created: 05/Feb/20 02:38
• Updated: 13/Nov/20 06:28
• Resolved: 13/Nov/20 06:28

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.