[jira] [Created] (SPARK-30708) first_value/last_value throws ParseException

["jiaan.geng (Jira)" <ji...@apache.org>]

jiaan.geng created SPARK-30708:
----------------------------------

             Summary: first_value/last_value throws ParseException
                 Key: SPARK-30708
                 URL: https://issues.apache.org/jira/browse/SPARK-30708
             Project: Spark
          Issue Type: Sub-task
          Components: SQL
    Affects Versions: 3.0.0
            Reporter: jiaan.geng


first_value/last_value throws ParseException

 
{code:java}
SELECT first_value(unique1) over w,
last_value(unique1) over w, unique1, four
FROM tenk1 WHERE unique1 < 10
+WINDOW w AS (order by four range between current row and unbounded following)
 
org.apache.spark.sql.catalyst.parser.ParseException
 
no viable alternative at input 'first_value'(line 1, pos 7)
 
== SQL ==
SELECT first_value(unique1) over w,
-------^^^
last_value(unique1) over w, unique1, four
FROM tenk1 WHERE unique1 < 10
WINDOW w AS (order by four range between current row and unbounded following)
{code}
 

Maybe we need fix this issue.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

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