What is the sorting arrangement for the array_agg function in SparkSQL?

edit

The array_agg function in SparkSQL does not have a specific sorting arrangement by default. It collects values from a group of input rows and returns them as an array, retaining the order of occurrence in the input rows. However, you can specify a custom sorting arrangement using the order by clause within the window function if required.