How to add partition using hive by a specific date?

[Sherine Brisillal]

Hi,

I'm using hive (with external tables) to process data stored on amazon S3.

My data is partitioned as follows:

                           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

My table looks like:

    CREATE EXTERNAL TABLE test (
        foo string,
        time string,
        bar string
    )  PARTITIONED BY (dt string)
    ROW FORMAT DELIMITED
    FIELDS TERMINATED BY '\t'
    LOCATION 's3://test.com/';

I don't want to use this( s3://test.com/dt=2014-03-05) naming convention, I
need to add all partitions as in:
*ALTER TABLE test  ADD PARTITION (dt='2014-03-09') location
's3://test.com/2014-03-09 <http://test.com/2014-03-09>'*. It's working
without any error. but, it doesn't load any data's from s3. output is 0
bytes. why isn't data loading from s3?

Could somebody answer this question ? Thanks!