[FLINK-26764] Support RESPECT NULLS for FIRST_VALUE/LAST_VALUE

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: 2.0.0
• Component/s: Table SQL / API, Table SQL / Planner
• Labels: pull-request-available stale-assigned
• Assignee: luoyuxia
• Reporter: luoyuxia
• Created: 21/Mar/22 08:09
• Updated: 10/Jul/24 06:57

Description

Flink supports fucntion FIRST_VALUE/LAST_VALUE, but the behavior is always ignore null value.

But the Spark, Hive, Oracle, Snowflake, etc, also support to respect null for FIRST_VALUE/LAST_VALUE.

Should we also support to allow users to specifc whether to ignore null?

Issue Links

• links to: GitHub Pull Request #19884
• links to: GitHub Pull Request #20130