Hey Shirley, Welcome to Hive! Once you've gotten Hive up and running and have created the "music" table, you should be able to say "EXPLAIN <query>", where <query> is the query specified below (or any other query). For more detailed information, you can say "EXPLAIN EXTENDED <query>".
The output from the EXPLAIN might be a little obtuse, so if you still have questions, I'm sure more knowledgeable Hive folks can give you insight into the planner. Regards, Jeff On Sat, Dec 20, 2008 at 11:48 AM, Shirley Cohen <[email protected]>wrote: > Hi, > > I'm just getting started with Hive. I was wondering if anyone can tell me > how Hive would translate the following SQL query into MapReduce: > > select distinct track, count(track) > from music > where date_listened between '12-10-2008' and '12-11-2008' > group by user > order by count(track) desc > > How many mapred jobs would it use? How would the map and red functions > looks like? Also, does Hive have a utility that gives you this information? > > Thanks, > > Shirley > > > >
