.**.***
/
--
RAVI SHETYE
Thanks to all your help I have moved ahead with my project.
So I create table as
CREATE TABLE test (...)
PARTITIONED BY (adid STRING, dt STRING)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
LOCATION 's3://logs/'
Do a *ALTER TABLE results RECOVER PARTITIONS;*
and then start querying.
Now the i
* *|
Here is an link to AWS forum, describing this in more detail -
https://forums.aws.amazon.com/thread.jspa?threadID=92862
Thanks,
Richin
*From:*ext Ravi Shetye [mailto:ravi.she...@vizury.com]
*Sent:* Friday, August 24, 2012 9:09 AM
*To:* user@hive.apache.org
*Subject:* Re: Hive on EMR on S
PM, Pedro Figueiredo wrote:
Hi,
On 24 Aug 2012, at 13:26, Ravi Shetye wrote:
I have the data in s3 bucket in the following manner
|s3://logs/ad1date1.log.gz
s3://logs/ad1date2.log.gz
s3://logs/ad1date3.log.gz
s3://logs/ad1date4.log.gz
s3://logs/ad2date1.log.gz
s3://logs/ad2date2.log.gz
s3://log
I have the data in s3 bucket in the following manner
|s3://logs/ad1date1.log.gz
s3://logs/ad1date2.log.gz
s3://logs/ad1date3.log.gz
s3://logs/ad1date4.log.gz
s3://logs/ad2date1.log.gz
s3://logs/ad2date2.log.gz
s3://logs/ad2date3.log.gz
s3://logs/ad2date4.log.gz
|
I have to load some of them into