Sergey Nuyanzin created FLINK-34587:
---------------------------------------
Summary: Suport MODE aggregate function
Key: FLINK-34587
URL: https://issues.apache.org/jira/browse/FLINK-34587
Project: Flink
Issue Type: Sub-task
Components: Table SQL / API
Reporter: Sergey Nuyanzin
Assignee: Sergey Nuyanzin
There is {{AVG}} function however sometimes it is required to find the most
repeatable item and {{MODE}} could be helpful to solve this
it is already supported by a number of vendors like DuckDB[1], Snowflake[2],
Spark [3], PostgreSQL[4]
[1] https://duckdb.org/docs/sql/aggregates.html
[2] https://docs.snowflake.com/en/sql-reference/functions/mode
[3] https://spark.apache.org/docs/latest/sql-ref-functions-builtin.html
[4] https://www.postgresql.org/docs/16/functions-aggregate.html
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
