StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POCounting documents in MapReduce depending on condition - MongoDB
text
Body
copied!<p>I am trying to use a Map Reduce to count number documents according to one of the field values per date. First, here are the results from a couple of regular find() functions:</p> <pre><code>db.errors.find({ "cDate" : ISODate("2012-11-20T00:00:00Z") }).count(); </code></pre> <p>returns 579 (ie. there are 579 documents for this date)</p> <pre><code>db.errors.find( { $and: [ { "cDate" : ISODate("2012-11-20T00:00:00Z") }, {"Type":"General"} ] } ).count() </code></pre> <p>returns 443 (ie. there are 443 documents for this date where Type="General")</p> <p>Following is my MapReduce:</p> <pre><code>db.runCommand({ mapreduce: "errors", map : function Map() { emit( this.cDate,//Holds a date value { count: 1, countGeneral: 1, Type: this.Type } ); }, reduce : function Reduce(key, values) { var reduced = {count:0,countGeneral:0,Type:''}; values.forEach(function(val) { reduced.count += val.count; if (val.Type === 'General') reduced.countGeneral += val.countGeneral; }); return reduced; }, finalize : function Finalize(key, reduced) { return reduced; }, query : { "cDate" : { "$gte" : ISODate("2012-11-20T00:00:00Z") } }, out : { inline : 1 } }); </code></pre> <p>For the date 20-11-20 the map reduce returns:</p> <pre><code>count: 579 countGeneral: 60 (should be 443 according to the above find query) </code></pre> <p>Now, I understand that the Reduce is unpredictable in the way it loops so how should I do this? Thanks </p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload