Skip to content

Instantly share code, notes, and snippets.

@dachev
Created December 30, 2011 10:31
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dachev/1539205 to your computer and use it in GitHub Desktop.
Save dachev/1539205 to your computer and use it in GitHub Desktop.
Find games with duplicate GameTeamStat records
var m = function() {
var key = this.stat_module_id + '_' + this.game_id + '_' + this.team_id;
emit(key, 1);
};
var r = function(k,vals) {
var sum = 0;
for (var i in vals) {
sum += vals[i];
}
return sum;
};
var opts = {query:{_type:'GameTeamStat'}, out:"myoutput"};
var res = db.game_stats.mapReduce(m, r, opts);
db.myoutput.find({value:{$gt:1}}).count()
db.myoutput.find({value:{$gt:1}})
db.myoutput.drop()
{ "_id" : "4e3a0df30dc38523a6000039_2130739_108634", "value" : 2 }
{ "_id" : "4e3a0df30dc38523a6000039_2140415_109947", "value" : 2 }
{ "_id" : "4e3a0df30dc38523a6000039_2274590_91890", "value" : 2 }
{ "_id" : "4e3a0df30dc38523a600003b_2403065_122578", "value" : 7 }
{ "_id" : "4e3a0df30dc38523a600003b_2403066_122600", "value" : 12 }
{ "_id" : "4e4d7931c0759f7c2b00001c_2146208_106780", "value" : 2 }
{ "_id" : "4e4d7931c0759f7c2b00001c_2146208_106782", "value" : 2 }
{ "_id" : "4ec1dea70a11c10fdb000001_1024787_38143", "value" : 2 }
{ "_id" : "4ec1dea70a11c10fdb000001_2346935_95144", "value" : 4 }
{ "_id" : "4ec1dea70a11c10fdb000001_2602949_116155", "value" : 2 }
{ "_id" : "4ec1dea70a11c10fdb000001_2783002_129084", "value" : 9 }
{ "_id" : "4ec1dea70a11c10fdb000001_2783081_129087", "value" : 2 }
{ "_id" : "4ec1dea70a11c10fdb000001_2783167_129082", "value" : 11 }
{ "_id" : "4ec1dea70a11c10fdb000001_2810756_120775", "value" : 2 }
{ "_id" : "4ec1dea70a11c10fdb000001_5801_11225", "value" : 2 }
{ "_id" : "4ec1dea70a11c10fdb000014_1024787_38143", "value" : 2 }
{ "_id" : "4ec1dea70a11c10fdb000014_2097418_92290", "value" : 2 }
{ "_id" : "4ec1dea70a11c10fdb000014_2196473_86261", "value" : 2 }
{ "_id" : "4ec1dea70a11c10fdb000014_2409178_109660", "value" : 2 }
{ "_id" : "4ec1dea70a11c10fdb000014_2845856_92292", "value" : 2 }
{ "_id" : "4ec1dea70a11c10fdb000014_5801_11225", "value" : 2 }
{ "_id" : "4ec1dea70a11c10fdb000021_1024787_38143", "value" : 2 }
{ "_id" : "4ec1dea70a11c10fdb000021_2214283_84955", "value" : 2 }
{ "_id" : "4ec1dea70a11c10fdb000021_2346935_95144", "value" : 4 }
{ "_id" : "4ec1dea70a11c10fdb000021_2602949_116155", "value" : 2 }
{ "_id" : "4ec1dea70a11c10fdb000021_2686585_120775", "value" : 3 }
{ "_id" : "4ec1dea70a11c10fdb000021_2783002_129084", "value" : 9 }
{ "_id" : "4ec1dea70a11c10fdb000021_2783081_129087", "value" : 2 }
{ "_id" : "4ec1dea70a11c10fdb000021_2783167_129082", "value" : 11 }
{ "_id" : "4ec1dea70a11c10fdb000021_2810756_0", "value" : 2 }
{ "_id" : "4ec1dea70a11c10fdb000021_2810756_120775", "value" : 2 }
{ "_id" : "4ec1dea70a11c10fdb000021_5801_11225", "value" : 2 }
{ "_id" : "4ec1dea70a11c10fdb000028_1024787_38143", "value" : 2 }
{ "_id" : "4ec1dea70a11c10fdb000028_2203735_116155", "value" : 2 }
{ "_id" : "4ec1dea70a11c10fdb000028_2203736_100110", "value" : 6 }
{ "_id" : "4ec1dea70a11c10fdb000028_2203738_100106", "value" : 3 }
{ "_id" : "4ec1dea70a11c10fdb000028_2346935_95144", "value" : 4 }
{ "_id" : "4ec1dea70a11c10fdb000028_2428952_0", "value" : 2 }
{ "_id" : "4ec1dea70a11c10fdb000028_2428953_109992", "value" : 2 }
{ "_id" : "4ec1dea70a11c10fdb000028_2602949_116155", "value" : 3 }
{ "_id" : "4ec1dea70a11c10fdb000028_2682825_126994", "value" : 2 }
{ "_id" : "4ec1dea70a11c10fdb000028_2682838_126997", "value" : 5 }
{ "_id" : "4ec1dea70a11c10fdb000028_2682934_126996", "value" : 5 }
{ "_id" : "4ec1dea70a11c10fdb000028_2682953_126995", "value" : 2 }
{ "_id" : "4ec1dea70a11c10fdb000028_2682957_126998", "value" : 2 }
{ "_id" : "4ec1dea70a11c10fdb000028_2682983_126997", "value" : 2 }
{ "_id" : "4ec1dea70a11c10fdb000028_2682989_126988", "value" : 2 }
{ "_id" : "4ec1dea70a11c10fdb000028_2683001_126990", "value" : 2 }
{ "_id" : "4ec1dea70a11c10fdb000028_2782926_129083", "value" : 2 }
{ "_id" : "4ec1dea70a11c10fdb000028_2783002_129084", "value" : 10 }
{ "_id" : "4ec1dea70a11c10fdb000028_2783047_129086", "value" : 2 }
{ "_id" : "4ec1dea70a11c10fdb000028_2783081_129087", "value" : 3 }
{ "_id" : "4ec1dea70a11c10fdb000028_2783130_129088", "value" : 2 }
{ "_id" : "4ec1dea70a11c10fdb000028_2783167_129082", "value" : 12 }
{ "_id" : "4ec1dea70a11c10fdb000028_5801_11225", "value" : 2 }
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment