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 <
lalamchinnara...@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*
