title: How to explode map datatype in Hive OR how to give multiple aliases in Hive
body: <p>Suppose I query : </p>
  
  <pre><code>select explode(map_column_name) as exploded from table_name 
  </code></pre>
  
  <p>I get this error:<br/></p>
  
  <blockquote>
    <p>The number of aliases in the AS clause does not match the number of
    columns output by the UDTF, expected 2 aliases but got 1</p>
  </blockquote>
  
  <p>and I googled the error and got to know that to give more than one alias , we use stack function .. 
  How to use stack function along with explode function so that I eventually explode map datatype and also give 2 aliases at a time?</p>
  
  <p>Kindly bear with me as I am a beginner and learning Hive.</p>