[
https://issues.apache.org/jira/browse/FLINK-21949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17337315#comment-17337315
]
Timo Walther commented on FLINK-21949:
--------------------------------------
+1 for ARRAY_AGG. We don't need to support all SQL standard keywords in the
first version. For that we would need Calcite support. For now we can do it
through a regular aggregate function. We can implement it with the new built-in
function stack first.
> 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)
