[FLINK-21911] Support GREATEST and LEAST functions in SQL

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.14.0
• Component/s: Table SQL / API
• Labels: auto-unassigned pull-request-available
• Assignee: Leonard Xu
• Reporter: Timo Walther
• Created: 22/Mar/21 09:45
• Updated: 23/Sep/21 18:09
• Resolved: 23/Jul/21 02:35

Description

We should discuss if we want to support math MIN / MAX in Flink SQL. It seems also other vendors do not support it out of the box:

https://stackoverflow.com/questions/124417/is-there-a-max-function-in-sql-server-that-takes-two-values-like-math-max-in-ne

But it might be quite useful and a common operation in JVM languages.

Issue Links

• links to: GitHub Pull Request #15821
• links to: GitHub Pull Request #16020