title: (AWS) Athena: Query Results seem too short
body: <p>My Athena queries appear to be too short in their results. Trying to figure out Why? </p>
  
  <p>Setup: </p>
  
  <p>Glue Catalogs (118.6 Gig in size). 
  Data: Stored in S3 in both CSV and JSON format. 
  Athena Query: When I query data for a whole table, I only get 40K results per Query, there should be 121Million Records for that query on average for one month's data.  </p>
  
  <p>Does Athena Cap query result data? Is this a service limit (the documentation does not suggest this to be the case). </p>