MongoDBとSQL文の比較

SELECT
 daily_info_id,
 SUM(imp_count) as sc,
 SUM(click_count) as scc,
 SUM(click_amount) as sca
FROM
 daily_info
WHERE daily_info_id = 200911241225
GROUP BY
 daily_info_id

var m = function(){ 
		emit(
			{k1:this.daily_info_id},
			{icsum : this.imp_count,
			 ccsum : this.click_count,
			 casum : this.click_amount
			}
		);
	};

var r = function(k, vals){
	var sum=0;
	var ret = {icsum:0,ccsum:0,casum:0}
	for(var i = 0; i < vals.length; i++){
		ret.icsum += vals[i].icsum;
		ret.ccsum += vals[i].ccsum;
		ret.casum += vals[i].casum;
	}
		
	return ret;
};

res = db.daily_info.mapReduce(m, r);

db[res.result].find({"_id" : {"k1":200911241225}});