title: Why AWS athena creating my table as a string instead of an array of nested objects
body: <p>Instead of a nested table all I get is one very long title containing the sql command but no errors. Why is it working but not actually inputing the json data correctly?</p>
  
  <pre><code>CREATE external TABLE ranked (
      airlineRankings array&lt;struct&lt;
      overall_rating:TINYINT,
      seat_comfort_rating:TINYINT,
      cabin_staff_rating:TINYINT,
      food_beverages_rating:TINYINT,
      inflight_entertainment_rating:TINYINT,
      ground_service_rating:TINYINT,
      wifi_connectivity_rating:TINYINT,
      value_money_rating:TINYINT,
      recommended:TINYINT,
      review_amount:TINYINT,
      count:TINYINT,
      iata:string,
      icao:string,
      airline_link:string,
      call_sign:string,
      country:string,
      airline:string
        &gt;&gt;
        )
      ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe'
      LOCATION 's3://**********/'
  </code></pre>
  
  <p>JSON data format:</p>
  
  <pre><code>{
      "airlineRankings": [{
          "iata": "",
          "icao": "EVY",
          "airline_link": "34 Squadron, Royal Australian Air Force",
          "call_sign": "",
          "country": "Australia",
          "airline": "34 Squadron, Royal Australian Air Force",
          "overall_rating": 0,
          "seat_comfort_rating": 0,
          "cabin_staff_rating": 0,
          "food_beverages_rating": 0,
          "inflight_entertainment_rating": 0,
          "ground_service_rating": 0,
          "wifi_connectivity_rating": 0,
          "value_money_rating": 0,
          "recommended": 0,
          "review_amount": 0
      }
  ]
  }
  </code></pre>