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?
Ashutosh Chauhan 2012-05-29, 20:24
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

Thanks,
Ashutosh

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
>