title: Run SQL-like queries across large JSON datasets, in the cloud?
body: <p>Is there a product that meets these requirements:</p>
  
  <ul>
  <li>running SQL-like queries (preferably with a friendly UI, though can use command line if necessary)</li>
  <li>across largely static JSON datasets of several million documents, without a consistent schema</li>
  <li>with the JSON documents stored in the cloud, not locally.</li>
  </ul>
  
  <p>Basically, I would like Google BigQuery, but without the requirement for a consistent pre-specified schema.</p>
  
  <p>Apache Drill offers SQL-like queries across large JSON datasets with different schemas. However, I don't think it works well on cloud-hosted datasets - have set it up to talk to an S3 bucket, and it seems to need to download all the data locally, which makes it unusable with large datasets.</p>