title: Hive query to map 3 array columns position wise
body: <pre><code>i/p:
  
  c1                        c2                        c3
  [[1,2,3],[4],[5,6]]       ['v1','v2','v3']          [['sam'], ['tam'], ['bam']] 
  
  o/p:
  
  c1                        c2                        c3
  [1,2,3]                   'v1'                      ['sam']
  [4]                       'v2'                      ['tam']
  [5,6]                     'v3'                      ['bam']
  </code></pre>
  
  <p>Can someone please suggest how do I go about writing a query for the above problem ?</p>