Mongodb mapreduce java 操作

最新推荐文章于 2021-02-26 15:41:56 发布

chixian4839

最新推荐文章于 2021-02-26 15:41:56 发布

阅读量119

点赞数

文章标签：数据库大数据 java

原文链接：https://my.oschina.net/u/2499632/blog/727752

版权

mongodb数据库中数据一览：

有多条个cust_id数据，现统计cust_id为abc124用户items下sl为0.17和0.13分别的总和是多少

java代码如下：

MongoClient mongoClient = new MongoClient("192.168.1.45", 27017);
MongoCollection mongoCollection = mongoClient.getDatabase("tt").getCollection("tt");
String mapFunction = "function(){\n" +
        "for(var i = 0; i < this.items.length; i++){\n" +
        "var key = this.items[i].sl;\n" +
        "var value = {\n" +
        "count:1,\n" +
        "je: this.items[i].je,\n" +
        "se: this.items[i].se\n" +
        "};\n" +
        "emit(key, value);\n" +
        "}};\n";
String reduceFunction = "function(key,values){\n" +
        "reduceVal = {je:0,se:0};\n" +
        "for(var i = 0; i < values.length; i++){\n" +
        "reduceVal.je += values[i].je;\n" +
        "reduceVal.se += values[i].se;\n" +
        "}\n" +
        "return reduceVal;};\n";


JSONObject query = new JSONObject();
query.put("cust_id", "abc124");//设置查询条件
Document queryDoc = Document.parse(query.toString());
MapReduceIterable mri = mongoCollection.mapReduce(mapFunction, reduceFunction).filter(queryDoc);
MongoCursor mongoCursor = mri.iterator();
JSONArray jsonArray = new JSONArray();
while (mongoCursor.hasNext()){
    JSONObject object = JSON.parseObject(((Document) mongoCursor.next()).toJson().toString());
    JSONObject jsonObject = new JSONObject();
    String sl = object.getString("_id");
    object.put("sl", sl);
    object.remove("_id");
    jsonArray.add(object);
}
System.out.println(jsonArray);

想要的功能已经实现，旧版的mongodb的mapreduce方法如下：

DBObject query = new BasicDBObject();
query.put("cust_id", "abc124");
Mongo mongo = new Mongo("192.168.1.45", 27017);
DB db = mongo.getDB("tt");
DBCollection collection = db.getCollection("tt");
MapReduceCommand mapReduceCommand =
        new MapReduceCommand(collection, mapFunction, reduceFunction, null, MapReduceCommand.OutputType.INLINE, query);
MapReduceOutput mapReduceOutput = collection.mapReduce(mapReduceCommand);
JSONArray jsonArray = new JSONArray();
for (DBObject o : mapReduceOutput.results()) {
    JSONObject jsonObject = JSON.parseObject(o.toString());
    String sl = jsonObject.getString("_id");
    jsonObject.put("sl", sl);
    jsonObject.remove("_id");
    jsonArray.add(jsonObject);
}
System.out.println(jsonArray);

当然我们还是推荐使用新版，官网参考：https://docs.mongodb.com/manual/tutorial/map-reduce-examples/

转载于:https://my.oschina.net/u/2499632/blog/727752