Hi It is definitely possible. In your map make the dept name as the output key and salary as the value.
In the reducer for every key you can initialize a counter and a sum. Add on to the sum for all values and increment the counter by 1 for each value. Output the dept key and the new aggregated sum and count for each key. Regards Bejoy KS Sent from handheld, please excuse typos. -----Original Message----- From: iwannaplay games <funnlearnfork...@gmail.com> Date: Fri, 5 Oct 2012 12:32:28 To: user<u...@hbase.apache.org>; <u...@hadoop.apache.org>; hdfs-user<hdfs-user@hadoop.apache.org> Reply-To: u...@hadoop.apache.org Subject: Multiple Aggregate functions in map reduce program Hi All, I have to get the count and sum of data for eg if my table is *employeename salary department* A 1000 testing B 2000 testing C 3000 development D 4000 testing E 1000 development F 5000 management I want result like Department TotalSalary count(employees) testing 7000 3 development 4000 2 management 5000 1 Please let me know whether it is possible to write a java map reduce for this.I tried this on hive.It takes time for big data.I heard map reduce java code will b faster.IS it true???Or i should go for pig programming?? Please guide.. Regards Prabhjot
