Re: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask

2010-12-20 Thread Sean Curtis
: Exceeded MAX_FAILED_UNIQUE_FETCHES; bailing-out. On Dec 20, 2010, at 11:01 PM, Adarsh Sharma wrote: > Sean Curtis wrote: >> just running a simple select count(1) from a table (using movielens as an >> example) doesnt seem to work for me. anyone know why this doesnt work? im

FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask

2010-12-20 Thread Sean Curtis
just running a simple select count(1) from a table (using movielens as an example) doesnt seem to work for me. anyone know why this doesnt work? im using hive trunk: hive> select avg(rating) from movierating where movieid=43; Total MapReduce jobs = 1 Launching Job 1 out of 1 Number of reduce ta

Re: hive newbie - importing data into hive

2010-12-14 Thread Sean Curtis
:36 PM, Bryan Talbot wrote: > I'll help by recommending that you get started by looking at the "Getting > Started Guide". > > http://wiki.apache.org/hadoop/Hive/GettingStarted > > > -Bryan > > > On Tue, Dec 14, 2010 at 8:23 PM, Sean Curtis wrote

hive newbie - importing data into hive

2010-12-14 Thread Sean Curtis
just wondering if i have a pipe delimited file, how i can just import this data into hive: basically i am using the microlens database, which is pipe separated. for example: user id | age | gender | occupation | zip code translates to 123 | 24 | M | worker | 12345 i'd like to just import th