> Hmm, man, there seems no UNNEST in Hive. But maybe it's introduced in a new > version.
I was mistaken. It’s PostgreSQL that has an UNNEST function and allows it in the SELECT clause [1]. Hive allows table functions in the SELECT clause, which has similar problems of multiplying rows [2]. Julian [1] https://www.postgresql.org/docs/9.2/functions-array.html <https://www.postgresql.org/docs/9.2/functions-array.html> [2] https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-explode(array) <https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-explode(array)>
