[SPARK-30708] first_value/last_value window function throws ParseException

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Jiaan Geng
• Created: 03/Feb/20 08:01
• Updated: 07/Feb/20 04:57
• Resolved: 07/Feb/20 04:57

Description

first_value/last_value throws ParseException

 

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)

 

Maybe we need fix this issue.

Issue Links

• links to: GitHub Pull Request #27442