Dylan Guedes created SPARK-28508:
------------------------------------

             Summary: Support for range frame+row frame in the same query
                 Key: SPARK-28508
                 URL: https://issues.apache.org/jira/browse/SPARK-28508
             Project: Spark
          Issue Type: Sub-task
          Components: SQL
    Affects Versions: 3.0.0
            Reporter: Dylan Guedes


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:

{code:sql}
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;
{code}



--
This message was sent by Atlassian JIRA
(v7.6.14#76016)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

Reply via email to