title: hive: cast array<struct<key:string,value:array<string>>> into map<string,array<string>>
body: <p>I have a hive table like </p>
  
  <pre><code>name            string                                      
  address         string                                      
  timezone        string                                      
  one_key_value   array&lt;struct&lt;key:string,value:array&lt;string&gt;&gt;                    
  two_key_value   array&lt;struct&lt;key:string,value:array&lt;string&gt;&gt;
  </code></pre>
  
  <p>and want to convert it to </p>
  
  <pre><code>name            string                                      
  address         string                                      
  timezone        string                                      
  one_key_value   map&lt;string,array&lt;string&gt;&gt;                       
  two_key_value   map&lt;string,array&lt;string&gt;&gt;
  </code></pre>
  
  <p>There is <code>explode(array)</code> but doesn't really return the entire table in the format I want. </p>