Github user mn-mikke commented on the issue:
https://github.com/apache/spark/pull/21102
It seems that Presto returns the result in ascending order.
```
presto> SELECT array_intersect(ARRAY[5, 8, null, 1], ARRAY[8, null, 1, 5]);
_col0
-----------------
[null, 1, 5, 8]
(1 row)
```
Shouldn't we follow the same behavior if Presto is used as a reference?
---
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
