title: Hive complex data type querying
body: <p>I am trying to query data from source table but I am unable to see the result properly.</p>
  
  <p><strong>Source table structure</strong></p>
  
  <pre><code>c1 string,
  c2 string,
  c3 string,
  temp1 struct
  &lt;
  s1 : string,
  s2 : string,
  s3 : string,
  temp2 : array&lt;struct&lt;as1 string,as2 :string&gt;&gt;                 
  &gt;
  </code></pre>
  
  <p>I have data in <strong>JSON</strong> format.</p>
  
  <p><strong>My JSON data is in the below format</strong></p>
  
  <pre><code>{"c1":"123","c2":"XYZ","c3":"IIK",
  "temp1":{"s1":"low","s2":"45","s3":"yes"},
  "temp2":[{"as1":"16-05-1992","as2":"fail"}]
  }
  </code></pre>
  
  <p>As per my table structure, I should have array(struct) inside struct. But the data I am having is not like that. I have struct separately and array(struct) separately. Now when I query this table, I get all the records for columns c1,c2,c3,s1,s2 as expected but I am not getting as1 and as2 columns instead I am getting <strong>temp2</strong> itself as <strong>null</strong> in the output.
  Am I missing anything here. Should I have the data like <code>struct&lt;array&lt;struct&gt;&gt;</code> or is it fine to split <code>struct</code> and <code>array&lt;struct&gt;</code> and json serde will take care while reading</p>