[window function] array_agg in window function

[wangsimo0]

starrocks support array_agg as a agg function.
https://docs.starrocks.io/docs/sql-reference/sql-functions/array-functions/array_agg/
but starrocks doesn't support it as a window function

[mygrsun]

I want to pick this one. @wangsimo0

[kateshaowanjou]

I want to pick this one. @wangsimo0
It's assigned to you. We have a function group for developers, I can add you to the group if you add my wechat:https://ma3you.com/articles_qrcode_show/b12e90J.png?le_time=230517193908378828

[mygrsun]

I want to pick this one. @wangsimo0
It's assigned to you. We have a function group for developers, I can add you to the group if you add my wechat:https://ma3you.com/articles_qrcode_show/b12e90J.png?le_time=230517193908378828

this picture is 404 now.please sent again,thanks.

[kateshaowanjou]

I want to pick this one. @wangsimo0
It's assigned to you. We have a function group for developers, I can add you to the group if you add my wechat:https://ma3you.com/articles_qrcode_show/b12e90J.png?le_time=230517193908378828

this picture is 404 now.please sent again,thanks.

New link:https://853921.ma3you.cn/articles/b12e90J/
Please let me know if it doesn't work. Thanks!

[github-actions]

We have marked this issue as stale because it has been inactive for 6 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to StarRocks!