Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> HIVE and S3 via EMR?

Copy link to this message
Re: HIVE and S3 via EMR?
Which hive version you are using? You need fix of
https://issues.apache.org/jira/browse/HIVE-1444 which was released in 0.9.0


On Tue, May 29, 2012 at 1:20 PM, Russell Jurney <[EMAIL PROTECTED]>wrote:

> How do I load data from S3 into Hive using Amazon EMR?  I've booted a
> small cluster, and I want to load a 3-column TSV file from Pig into a table
> like this:
> create table from_to (from_address string, to_address string, dt string);
> When I run something like this:
> load data inpath 's3n://rjurney_public_web/from_to_date' into table
> from_to;
> I get errors:
> FAILED: Error in semantic analysis: Line 1:17 Invalid path
> 's3n://rjurney_public_web/from_to_date': only "file" or "hdfs" file systems
> accepted. s3n file system is not supported.
> There is no distcp on the master node of my EMR cluster, so I can't copy
> it over.  I've read the documentation... and so far after a day of trying,
> I can't load data into HIVE via EMR.
> What am I missing?  Thanks!
> --
> Russell Jurney twitter.com/rjurney [EMAIL PROTECTED] datasyndrome.
> com