Check if this link provides any help:

http://aws.amazon.com/elasticmapreduce/faqs/#hive-2

read " Are there new features in Hive specific to Amazon Elastic MapReduce?"

and 

http://aws.amazon.com/articles/2856
 

Best regards,
Michael


________________________________
From: Raimon Bosch <raimon.bo...@gmail.com>
To: user@hive.apache.org
Sent: Friday, November 11, 2011 10:40 AM
Subject: load data from s3 to hive




Hi,

I have read that hadoop supports native operations over S3 Filesystem so you're 
able to perform operations like:

hadoop fs -ls s3n://mybucket/my_folder/

or:

hadoop fs -copy s3n://mybucket/my_folder /tmp/my_folder

I'm wondering why hive is not able to perform similar operations. It would be a 
very good feature load data directly from S3 to Hive, something like:

hive -e "LOAD DATA LOCAL INPATH 's3n://mybucket/my_hive_table' INTO 
TABLE my_hive_table PARTITION(dt='2011-11-11');"

Right now this is not possible. What do you think? Which classes should be 
changed?

Reply via email to