title: AWS Athena unable to convert .csv integers to table values
body: <p>I have a simple csv file here</p>
  
  <pre><code>Joe, 30, Male, 3
  Winston, 40, Male, 7
  Emily, 18, Female, 5
  Wendy, 32, Female, 4
  </code></pre>
  
  <p>Which I uploaded to an S3 bucket on AWS. Then, using Athena, I created a table with</p>
  
  <ul>
  <li>Correct S3 bucket path</li>
  <li>.csv as Data formt</li>
  <li>Columns as <code>name string, age int, gender string, consumed int</code></li>
  </ul>
  
  <p>The table is created successfully, but when I query it, only <code>name</code> and <code>gender</code> are there. The columns <code>age</code> and <code>consumed</code> are empty for all entries. Any ideas?</p>