title: How to partition a datetime column when creating Athena table
body: <p>I have some log files in S3 with the following csv format (sample data in parenthesis):</p>
  
  <pre><code>userid (15678),
  datetime (2017-09-14T00:21:10),
  tag1 (some random text),
  tag2 (some random text)
  </code></pre>
  
  <p>I want to load into Athena tables and partition the data based on datetime in a day/month/year format.  Is there a way to split the datetime on table creation or do I need to run some job before to separate the columns and then import?</p>