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).
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).
Do I need to sort records in file by date to get better performance?
Will the Athena just scan from first record to the last one and than give me the result?
