hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sherine Brisillal <sherinebr...@gmail.com>
Subject Re: How to add partition using hive by a specific date?
Date Tue, 11 Mar 2014 10:53:58 GMT
Thanks for your Response!!

hive> LOAD DATA INPATH 's3://test.com/' OVERWRITE INTO TABLE test PARTITION
(dt='2014-01-01');
FAILED: Error in semantic analysis: line 1:17 Invalid Path 's3://test.com/':
only "file" or "hdfs" file systems accepted. s3 file system is not
supported.

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


On Tue, Mar 11, 2014 at 3:03 PM, Chinna Rao Lalam <
lalamchinnarao13@gmail.com> wrote:

> Hi,
>
>   Any exceptions in the log file?
>
>
>   Try this for loading into partions. In your scenario if it is possible
> with load query.
>   LOAD DATA INPATH '/user/myname/kv2.txt' OVERWRITE INTO TABLE invites
> PARTITION (ds='2008-08-15');
>
>
> Hope it helps,
> Chinna
>
>>
>>
>


-- 

*Regards*
*Sherine Brisillal*

Mime
View raw message