Hadoop, mapreduce, sql

Post Client Info Here

Implement the following sql in mapreduce. I'll provide you the data file.

SELECT u.Occupation, COUNT(u.UserID) FROM users u
WHERE u.Age = 25
GROUP BY u.Occupation
;
/* output: */
12::181 [tab] UsersTable

Proposals