title: What is the equivalent of Presto UNNEST function in Hive
body: <p>Presto has an <code>UNNEST</code> function to explode columns made of arrays. Is there a similar one for Hive?
  See docs for <code>UNNEST</code> function of Presto <a href="https://prestodb.io/docs/current/sql/select.html" rel="nofollow noreferrer">here</a>.</p>