Re: hive : question about reducers

2011-02-10 Thread Jonathan Coveney
How many days of data are you working on? Sent via BlackBerry -Original Message- From: Viral Bajaria Date: Thu, 10 Feb 2011 15:21:32 To: Reply-To: user@hive.apache.org Subject: Re: hive : question about reducers I don't have any explicit bucketing in my data. The data is partitioned b

Re: Is there a reason why this simple query would take a very long time?

2011-01-24 Thread Jonathan Coveney
reduce.tasks=4; > > > > set this before doing the select. > > > > -Ajo > > > > On Mon, Jan 24, 2011 at 1:13 PM, Jonathan Coveney > wrote: > >> I have a 10 node server or so, and have been mainly using pig on it, but > >> would like to tr

Is there a reason why this simple query would take a very long time?

2011-01-24 Thread Jonathan Coveney
I have a 10 node server or so, and have been mainly using pig on it, but would like to try out Hive. I am running this query, which doesn't take too long in Pig, but is taking quite a long time in Hive. hive -e "select count(1) as ct from my_table where v1='02' and v2 = ;" > thecount One

Using a SQL-esque program to run Hive jobs?

2010-12-27 Thread Jonathan Coveney
I apologize in advance if this is a basic question... I haven't found a straight answer to the question, though, and am new to Hive so forgive the ignorance. I've done some searching around, and it looks like HUE may be one solution, but pending looking into that, I was wondering if anyone has use