[ https://issues.apache.org/jira/browse/FLINK-21949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17337051#comment-17337051 ]
Jark Wu commented on FLINK-21949: --------------------------------- Thanks [~jiabao.sun], the {{collect_list}} and {{collect_set}} sounds good to me. [~Sergey Nuyanzin] is designing built-in functions related to collections, would be great to hear opinions from him. > 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)