[SPARK-28508] Support for range frame+row frame in the same query

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Invalid
• Affects Version/s: 3.1.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Dylan Guedes
• Created: 24/Jul/19 17:45
• Updated: 25/Nov/20 09:42
• Resolved: 25/Nov/20 09:42

Description

Currently, looks like some queries does not works if both, a range frame and a row frame are given. However, PgSQL is able to handle them:

select last(salary) over(order by enroll_date range between 1 preceding and 1 following), lag(salary) over(order by enroll_date range between 1 preceding and 1 following),
salary, enroll_date from empsalary;