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: [email protected]
For additional commands, e-mail: [email protected]
