RE: Number of map reduce jobs generated

2011-03-25 Thread Tim Kaldewey
2011 05:02 PM Subject: RE: Number of map reduce jobs generated In this case would 2 M/R job run faster than one? From: Tim Kaldewey [mailto:tkal...@us.ibm.com] Sent: Thursday, March 24, 2011 2:30 PM To: user@hive.apache.org Subject: Number of map reduce jobs generated Hello, I notice

RE: Number of map reduce jobs generated

2011-03-24 Thread Sudhish Iyer
In this case would 2 M/R job run faster than one? From: Tim Kaldewey [mailto:tkal...@us.ibm.com] Sent: Thursday, March 24, 2011 2:30 PM To: user@hive.apache.org Subject: Number of map reduce jobs generated Hello, I noticed that for join queries that comprise an aggregate hive generates a

Number of map reduce jobs generated

2011-03-24 Thread Tim Kaldewey
Hello, I noticed that for join queries that comprise an aggregate hive generates a query plan with two MR jobs, one does the join and the second the aggregate. I was wondering if there is a way to hint hive to combine these two operations in 1 MR job. I have attached an example of the set of que