[SPARK-34096] Improve performance for nth_value ignore nulls over offset window

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.2.0
• Fix Version/s: 3.2.0
• Component/s: SQL
• Assignee: Jiaan Geng
• Reporter: Jiaan Geng
• Created: 13/Jan/21 08:09
• Updated: 08/May/21 09:17
• Resolved: 21/Jan/21 07:31

Description

The current

UnboundedOffsetWindowFunctionFrame

and

UnboundedPrecedingOffsetWindowFunctionFrame

only support nth_value that respect nulls. So nth_value will execute

updateExpressions

multiple times.

Issue Links

• links to: [Github] Pull Request #31178 (beliefer)