title: HIVE nested ARRAY in MAP data type
body: <p>I have HIVE table structured like this:-</p>
  
  <pre><code>Create table test_stg(employee_id INT, name STRING, abu ARRAY &lt;String&gt;, sabu MAP &lt;String, ARRAY&lt;INT&gt;)
  row format delimited fields terminated by '|'                                                              
  collection items terminated by '/'                                                                         
  map keys terminated by ':'; 
  </code></pre>
  
  <p>I will import the data from local file system using <code>LOAD DATA LOCAL....</code></p>
  
  <p>The question is how should I frame the contents of my local file so that Map datatype field <em>sabu</em> can have nested array.</p>
  
  <p>Thanks in advance.</p>