0

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

Python Learner
  • 185
  • 1
  • 12

1 Answers1

0

For those wondering, this is equivalent to

LATERAL VIEW OUTER explode()
Python Learner
  • 185
  • 1
  • 12