mongodb的分组排序取第一条

最新推荐文章于 2024-07-26 03:39:24 发布

代码复制从业者

最新推荐文章于 2024-07-26 03:39:24 发布

阅读量5.8k

点赞数

分类专栏： mongo 文章标签： mongo mongotemplate mapreduc

本文链接：https://blog.csdn.net/qq_26398033/article/details/82379717

版权

mongo 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

mongotemplate的mapreduce方法

reduce的处理条数超过100时会用两个reduce处理第二次调reduce函数时 fixCardValue和chargeDate会重新初始化然后抛异常

//根据car_no分组，charge_date时间排序，取最近一条记录的fix_card_value
Criteria criteria = Criteria.where("project_id").is(project_id);
Query query = new Query(criteria);
String map = "function(){"
        + "emit("
        +        "this.car_no,"
        +        "{fixCardValue:this.fix_card_value,chargeDate:this.charge_date}"
        +       ");"
        +  "}";
String reducef = "function(key,values){" +
        "var fixCardValue = values[0].fixCardValue;" +
        "var chargeDate = values[0].chargeDate;"+
        "for(var i=1;i<values.length;i++){" +
        "if(values[i].chargeDate>chargeDate){" +
        "fixCardValue = values[i].fixCardValue};" +
        "} " +
        "return fixCardValue;}";
MapReduceResults<BasicDBObject> mapReduceResults =
        mongoTemplate.mapReduce(query, "charge_data", map, reducef, BasicDBObject.class);
Iterator iterator = mapReduceResults.iterator();
while (iterator.hasNext()) {
    String jsonString = iterator.next().toString();
    JSONObject jsonObject = JSONObject.parseObject(jsonString);
    String key = jsonObject.getString("_id");
    int  value = jsonObject.getJSONObject("value").getDouble("fixCardValue").intValue();
 }

reduce的处理条数超过100时会用两个reduce处理第二次调reduce函数时 fixCardValue和chargeDate会重新初始化然后抛异常

将reduce函数改下如下方式：

String reducef = "function(key,values){" +
        "var fixCardValue = 999;" +
        "var chargeDate = '1970-01-01';" +
        "for(var i=0;i<values.length;i++){" +
        "if(values[i].chargeDate>chargeDate){" +
        "fixCardValue = values[i].fixCardValue};" +
        "} " +
        "return fixCardValue;}";