Re: How to add partition using hive by a specific date?

2014-03-11 Thread Sherine Brisillal
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 partition

Re: How to add partition using hive by a specific date?

2014-03-11 Thread Chinna Rao Lalam
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 > >

How to add partition using hive by a specific date?

2014-03-11 Thread 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/