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?