title: Querying Amazon Athena with partitions
body: <p>Let's say I want to have partitions by some attribute and in each
  partition I have couple of files with records in JSON (each file has more records).</p>
  
  <p>I want to query them by some attribute that specifies when the record is created for specific attribute (give me all records created before some date).</p>
  
  <p>Do I need to sort records in file by date to get better performance?</p>
  
  <p>Will the Athena just scan from first record to the last one and than
  give me the result?</p>