Hi all,
I have a specific question regarding array unpacking for quite a crucial use case. I have a query like the following:
ARRAY(
SELECT distinct field1 FROM UNNEST(array_col) as field1
--ORDER BY OFFSET
LIMIT 100
) AS distinct_array
FROM
table1
;```
So array_col is ordered when coming in as an input in the order I want. I basically want to run dedup and limit 100.
So far the order seems preserved, but I would need to know if that is guaranteed or not as in the ARRAY official documentation it is specifically written that the order might be affected (Again in practice the order seems to be maintained)