title: Alternative to create more than 100 partitions on Athena CTAS
body: <p>I'm currently creating some new tables from information stored in Amazon S3. First time using AWS, today I learn that Amazon Athena can't create more than 100 partitions from a CTAS query.</p>
  
  <p>I'm doing the transformations using sql, it works perfectly, but need a way to store more than 100 partitions at once to make the process more reliable.</p>
  
  <p>I'm setting the partition on date, so in 4 months my process is going to fail if I need to recreate the table to load a large amount of data via sql (where I have the transformations).</p>
  
  <p>Any idea of how can I achieve this?</p>