[
https://issues.apache.org/jira/browse/FLINK-21949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17337348#comment-17337348
]
Jark Wu commented on FLINK-21949:
---------------------------------
The only concern of ARRAY_AGG from my side is it sounds similar to LISTAGG,
however returns different type (ARRAY vs. STRING).
LISTAGG is introduced in SQL-2016: https://modern-sql.com/feature/listagg
> Support collect to array aggregate function
> -------------------------------------------
>
> Key: FLINK-21949
> URL: https://issues.apache.org/jira/browse/FLINK-21949
> Project: Flink
> Issue Type: Sub-task
> Components: Table SQL / API
> Affects Versions: 1.12.0
> Reporter: jiabao sun
> Priority: Minor
>
> Some nosql databases like mongodb and elasticsearch support nested data types.
> Aggregating multiple rows into ARRAY<ROW> is a common requirement.
> The CollectToArray function is similar to Collect, except that it returns
> ARRAY<ROW> instead of MULTISET<ROW>.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
