...
Description
Creates a list of all non-null values seen in a group (currently, max. 1000 values are collected). The order of elements isn't stable when running on a cluster, because the elements for each group might be collected on different nodes. If the element order matters, provide an order by expression as a second (optional) argument. This could, for example, be a timestamp or ID column in your data set.
...