This message was deleted.

The document of ARRAY_AGG () actually says

Use of ORDER BY within the ARRAY_AGG expression is not currently supported, and the ordering of results within the output array may vary depending on processing order.

So I guess the answer is no way?

yeah, the order in which results are merged can vary depending on the placement of segments among data servers

Hi @Clint Wylie , thank you for getting back to me. Is it possible to maintain the order? Like using cluster by or something? Thanks!