title: Can you add more than one partition in one "ALTER TABLE" command?
body: <p>I'm using Amazon Athena to query through some log files stored in an S3 bucket, and am using partitions to section off days of the year for the files I need to query. I was wondering -- since I have a large batch of days to add to my table, could I do it all in one <code>ALTER TABLE</code> command, or do I need to have as many <code>ALTER TABLE</code> commands as the number of partitions I would like to create? </p>
  
  <p>This is an example of the command I am using at the moment:</p>
  
  <pre><code>ALTER TABLE
    logfiles
  ADD PARTITION
    (day='20170525')
  location 's3://log-bucket/20170525/';
  </code></pre>
  
  <p>If I do have to use one <code>ALTER TABLE</code> command per partition, is there a way to create a range of days, and then have Athena loop through it to create the partitions, instead of me manually copy/pasting out this command 100+ times? </p>