title: How to add partition using hive by a specific date?
body: <p>I'm using hive (with external tables) to process data stored on amazon S3.</p>
  
  <p>My data is partitioned as follows: </p>
  
  <pre><code>                       DIR   s3://test.com/2014-03-01/
                         DIR   s3://test.com/2014-03-02/
                         DIR   s3://test.com/2014-03-03/
                         DIR   s3://test.com/2014-03-04/
                         DIR   s3://test.com/2014-03-05/
  
  s3://test.com/2014-03-05/ip-foo-request-2014-03-05_04-20_00-49.log
  s3://test.com/2014-03-05/ip-foo-request-2014-03-05_06-26_19-56.log
  s3://test.com/2014-03-05/ip-foo-request-2014-03-05_15-20_12-53.log
  s3://test.com/2014-03-05/ip-foo-request-2014-03-05_22-54_27-19.log
  </code></pre>
  
  <p>How to create a partition table using hive?</p>
  
  <pre><code>   CREATE EXTERNAL TABLE test (
      foo string,
      time string,
      bar string
      )  PARTITIONED BY (? string)
      ROW FORMAT DELIMITED
      FIELDS TERMINATED BY '\t'
      LOCATION 's3://test.com/';
  </code></pre>
  
  <p>Could somebody answer this question ? Thanks!</p>