Currently, Spark does not have a `random()` function. Postgres, however, does.
For instance, this one is not valid:
SELECT rank() OVER (ORDER BY rank() OVER (ORDER BY random()))
Because of the `random()` call. On the other hand, Postgres has it.
SPARK-28406 Port union.sql
SPARK-23160 Port window.sql
- links to