Actions

Round

From NoSQLZoo

Revision as of 02:46, 6 April 2018 by 40166222 (talk | contribs) (Update to mongo shell.)

Rounding is easy inside a MapReduce as it is possible to use the Math object provided by JavaScript.
More information on Math can be found here.

At the time of writing the aggregation() method has no rounding functions, though it is still doable with $mod and $multiply, as shown here by the lead project manager at MongoDB.

MapReduce

db.world.mapReduce(
  function(){
    emit(this.name, this.population);
  }, 
  function(key, values){
    return values;
  },
  {
    finalize: function(key,values){
      return {
          "population": values,
          "population in millions": Math.round(values/1000000)
      };
    },
    out: {inline: 1},
    query: {"name": "United Kingdom"}
  }
)

Aggregate

db.world.aggregate([
  {"$match": {"name": "United Kingdom"}},
  {"$project":{
    "_id": 1,
    "name": 1,
    "population":{"$divide": ["$population", 1000000]}
  }},
  {"$project":{
    "_id": 0,
    "name": 1,
    "population": '$population',
    "population in millions":{
      "$divide":[
        {"$subtract":[
          {"$multiply": ['$population', 100]},
          {"$mod": [{"$multiply": ['$population',100]}, 1]}
        ]},
        100
      ]
    }
  }}
]).pretty()
  • You have been served by: dill