title: Create Athena table from nested json source
body: <p>How shall I create a Athena table from the nested json file  ? This is my sample json file. I only need selected key value pairs like roofcondition and garagestalls.</p>
  
  <pre><code>{   "reportId":"7bc7fa76-bf53-4c21-85d6-118f6a8f4244",
  "reportOrderedTS":"1529996028730",
  "createdTS":"1530304910154",
  "report":"{'summaryElements': [{'value': 'GOOD', 'key': 'roofCondition'}, 
  {'value': '98', 'key': 'storiesConfidence'}{'value': '0', 'key': 
  'garageStalls'}], 'elements': [{'source': 'xyz', 'imageId': '0xxx_png', 
  'modelVersion': '1.21.0', 'key': 'pool'},  {'source': 'xyz', 'imageId': '0111_png', 'value': 'GOOD', 'modelVersion': '1.36.0', 'key': 'roofCondition','confidence': '49'}],    }", "status":"Success", "reportReceivedTS":"1529996033830" }
  </code></pre>