title: Create table and query json data using Amazon Athena?
body: <p>I want to query JSON data of format using Amazon Athena:</p>
  
  <pre><code>[{"id":"0581b7c92be",
    "key":"0581b7c92be",
    "value":{"rev":"1-ceeeecaa040"},
    "doc":{"_id":"0581b7c92be497d19e5ab51e577ada12","_rev":"1ceeeecaa04","node":"belt","DeviceId":"C001"}},
   {"id":"0581b7c92be49",
    "key":"0581b7c92be497d19e5",
    "value":{"rev":"1-ceeeecaa04031842d3ca"},
    "doc":{"_id":"0581b7c92be497","_rev":"1ceeeecaa040318","node":"belt","DeviceId":"C001"}
   }
  ]
  </code></pre>