'Translate LEFT JOIN UNNEST in Presto/Trino to Hive [duplicate]

Was wondering what the equivalent of the below in Presto/Trino is

LEFT JOIN UNNEST(colname) as t(renamedcol) on true

On Hive

I know CROSS JOIN UNNEST translates to LATERAL VIEW EXPLODE but I can't figure out the syntax for LEFT JOIN UNNEST for whatever reason

sqlhivehiveqlprestotrino


Solution 1:[1]

For those wondering, this is equivalent to

LATERAL VIEW OUTER explode()

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Python Learner

Related Questions