title: How to explode array of map in Hive
body: <p>Consider a table <code>my_table</code> with the following structure:</p>
  
  <pre><code>&gt;&gt; describe my_table
  
  id               bigint
  info_detail      map&lt;bigint,array&lt;string&gt;&gt;
  </code></pre>
  
  <p>If I explode <code>info_detail</code>, I end up with arrays:</p>
  
  <pre><code>&gt;&gt; select explode(info_detail) as (info_id, detail) 
     from my_table
  
     info_id  detail
     112344   ["something about 112344", "other things"]
     342302   ["something about 342302"]
  </code></pre>
  
  <p>How to explode <code>detail</code> as well, so result looks something like this:</p>
  
  <pre><code>   info_id  detail
     112344   "something about 112344"
     112344   "other things"
     342302   "something about 342302"
  </code></pre>