[
https://issues.apache.org/jira/browse/FLINK-34587?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergey Nuyanzin updated FLINK-34587:
------------------------------------
Summary: Support MODE aggregate function (was: Suport MODE aggregate
function)
> Support 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
> Priority: Major
>
> 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)
