title: load struct or any other complex data type in hive
body: <p>I have a <code>.xlsx</code> file which contains data some thing like the below image, am trying to create  using the below create query</p>
  
  <pre><code>CREATE TABLE aus_aboriginal(
      code int,
      area_name string,
      male_0_4 STRUCT&lt;num:double, total:double, perc:double&gt;,
      male_5_9 STRUCT&lt;num:double, total:double, perc:double&gt;,
      male_10_14 STRUCT&lt;num:double, total:double, perc:double&gt;,
      male_15_19 STRUCT&lt;num:double, total:double, perc:double&gt;,
      male_20_24 STRUCT&lt;num:double, total:double, perc:double&gt;,
      male_25_29 STRUCT&lt;num:double, total:double, perc:double&gt;,
      male_30_34 STRUCT&lt;num:double, total:double, perc:double&gt;,
      male_35_39 STRUCT&lt;num:double, total:double, perc:double&gt;,
      male_40_44 STRUCT&lt;num:double, total:double, perc:double&gt;,
      male_45_49 STRUCT&lt;num:double, total:double, perc:double&gt;,
      male_50_54 STRUCT&lt;num:double, total:double, perc:double&gt;,
      male_55_59 STRUCT&lt;num:double, total:double, perc:double&gt;,
      male_60_64 STRUCT&lt;num:double, total:double, perc:double&gt;,
      male_above_65 STRUCT&lt;num:double, total:double, perc:double&gt;)
  ROW FORMAT DELIMITED
  FIELDS TERMINATED BY '\t';
  </code></pre>
  
  <p>When I load the data into it I get <code>nulls</code> <img src="https://i.stack.imgur.com/bAxoI.png" alt="enter image description here"> What am I missing in <code>CREATE TABLE..</code>?</p>