title: Hive SQL querying struct columns
body: <p>I have the following table setup</p>
  
  <pre><code>mytable(table)
    foods(array&lt;struct&lt;pizza&lt;struct&lt;cheese:string, meat:string, mushroom,string&gt; pancake:string&gt;)
      pizza(array)
        cheese(string)
        meat(string)
        mushroom(string)
      pancake(string)
  </code></pre>
  
  <p>I'm trying to select a single column from the pizza array I am using</p>
  
  <pre><code>select foods.pizza.cheese from mytable;
  </code></pre>
  
  <p>But I get this error:</p>
  
  <blockquote>
    <p>Operator is only supported on struct or list of struct types</p>
  </blockquote>
  
  <p>Is there a way I can select those columns on an individual level?</p>