[SPARK-27951] ANSI SQL: NTH_VALUE function

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.1.0
• Fix Version/s: 3.1.0
• Component/s: SQL
• Assignee: Jiaan Geng
• Reporter: Zhu, Lipeng
• Created: 05/Jun/19 04:44
• Updated: 08/May/21 09:23
• Resolved: 18/Sep/20 07:07

Description

nth_value({{valueany, nthinteger)}}

same type as value

returns value evaluated at the row that is the nth row of the window frame (counting from 1); null if no such row

https://www.postgresql.org/docs/8.4/functions-window.html

Issue Links

• is related to: SPARK-33020 Add nth_value in PySpark API
• links to: [Github] Pull Request #28685 (beliefer)
• links to: [Github] Pull Request #29556 (beliefer)
• links to: [Github] Pull Request #29556 (beliefer)
• links to: [Github] Pull Request #29604 (beliefer)
• links to: [Github] Pull Request #29604 (beliefer)
• links to: [Github] Pull Request #29886 (beliefer)
• links to: GitHub Pull Request #27440