Converting PostgreSQL unnest(array[]) to Apache Impala syntax I have a query in Postgres that needs to be ported to Impala SQL. It looks like this: