{"jobName":"392e7c07-4823-44544-314ecad8f2dd_20181115T23_18_UTC","accountId":"91111111111","results":{"transcripts":[{"transcript":


CREATE external TABLE comp.convo (
   jobName string,
   result struct<
               results:struct<
               transcripts:array<
                                 transcript:string
                                >
                   >
  >
   )
ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe'
LOCATION 's3://nnnnnnnnnnnn/';