title: How does AWS Athena react to schema changes in S3 files?
body: <p>What happens when after creating the table in AWS Athena for files on S3, the structure of the files on S3 change?</p>
  
  <p>For eg:</p>
  
  <ol>
  <li><p>If the files previously had 5 columns when the table was created and later the new files started getting 1 more column:
  a) at the end?
  b) in between?</p></li>
  <li><p>What happens when some columns are not available in new files?</p></li>
  <li><p>What happens when the columns remain the same but the column order changes?</p></li>
  <li><p>Can we alter Athena tables to adjust to these changes?</p></li>
  </ol>