jjzjj

aggregation

全部标签

java - Spring 数据 MongoDB : aggregation framework - sort with nested property throws invalid reference

我找到了thisarticleinSpringForum这显然部分讨论了相同的问题,但没有回答我的问题。给定以下文档...{"_id":{"$oid":"5214b5d529ee12460939e2ba"},"title":"thisismytitle","tags":["fun","sport"],"comments":[{"author":"alex","text":"thisiscool","createdAt":1},{"author":"sam","text":"thisisbad","createdAt":2},{"author":"jenny","text":"thisi

mongodb - 按多个字段对值进行分组

我有这些文件:{"Sigle_1":"BIOS","Sigle_2":"BFTA"},{"Sigle_1":"BERP","Sigle_2":"BEST"},{"Sigle_1":"BHDL","Sigle_2":"BIOS"},{"Sigle_1":"BIPM","Sigle_2":"BEST"},{"Sigle_1":"BHDL","Sigle_2":"BIOS"}我如何发出一个请求,它将连接Sigle_1和Sigle_2以及组值reslut?预期结果示例:{"Sigle":"BIOS",},{"Sigle":"BFTA",},{"Sigle":"BERP",},{"Sigle":

java - 在 Spring MongoDB 的 ReplaceRoot 管道阶段使用 $mergeObjects

我希望将此代码片段重现为Java代码:db.getCollection('admins_comptes_client_ceov4').aggregate([{$lookup:{from:"contrats_ceov4",localField:"CUSTOMERNUMBER",foreignField:"CUSTOMERNUMBER",as:"arrayForeignObject"}{$unwind:{path:"$arrayForeignObject",preserveNullAndEmptyArrays:true}},{$replaceRoot:{newRoot:{$mergeObj

javascript - 如何获取 mongodb 聚合上所有条目的对象数组的值重复计数

我有这样的数据结构:{"_id":ObjectId("5c4404906736bd2608e30b5e"),"assets":[{"name":"xa","id":1},{"name":"xs","id":2}]},{"_id":ObjectId("5c4404906736bd2608e30b5f"),"assets":[{"name":"xa","id":3}]},{"_id":ObjectId("5c4404906736bd2608e30b5g"),"assets":[{"name":"xa","id":4},{"name":"xd","id":5},{"name":"xs","i

MongoDB(Java): How to cancel map-reduce (or aggregate)

我是MongoDB世界的新手,我正在使用Java驱动程序(2.12)连接到MongoDB服务器(2.6)。是否有取消MapReduceCommand(或正在进行的.aggregate()操作)的方法?我没有在文档中找到任何内容。 最佳答案 我也不确定是否有直接的API方法,但像大多数mongo操作一样,这些实际上只是通过对“系统集合”进行类似的有线协议(protocol)操作来发挥作用。所以查找和取消的方法记录在db.currentOp()下和db.killOp().这些是shell实现方法,他们正在做的所有id访问下面的“系统集合

java - Mongodb Java 驱动在聚合查询中的使用限制

问题查询工作正常但没有限制和跳过,它正在一次获取所有记录。请指出我做错了什么。MongoDB集合{"_id":ObjectId("559666c4e4b07a176940c94f"),"postId":"559542b1e4b0108c9b6f390e","user":{"userId":"5596598ce4b07a176940c943","displayName":"User1","username":"user1","image":""},"postFor":{"type":"none","typeId":""},"actionType":"like","isActive":1,

spring - 如何获取距离 - MongoDB Template Near 函数

我正在尝试查找附近的地点。下面的代码工作正常。但是我无法根据给定的纬度、经度获得实际的位置距离。Criteriacriteria=newCriteria("coordinates").near(newPoint(searchRequest.getLat(),searchRequest.getLng()));Queryquery=newQuery();query.addCriteria(criteria);query.addCriteria(criteriaName);query.limit(5);Listls=(List)mongoTemplate.find(query,Place.c

java - Spring Data + Mongo- 无分组字段求和

我有这样的匹配标准-Criteriacriteria=newCriteria().and("paidMobileMetadata").in(metadataList).and("localDate").gt(startDate).lte(endDate);现在我想得到字段的总和,说“钱”属于上述标准,而不对某些字段进行分组。早些时候我遇到了同样的问题,我必须在某个字段上对这个匹配标准进行分组,我是这样做的-Aggregationagg=Aggregation.newAggregation(Aggregation.match(newCriteria().and("paidMobileMe

java - 无法将聚合查询从 mongodb 转换为 Spring Data MongoDb

我在尝试使用聚合对象将我在mongodb中的查询转换为SpringDataMongoDb时遇到了问题。我在mongo中有以下文档:{"_id":ObjectId("596ce468798b61179c6442bb"),"_class":"com.test.model.User","name":"Oi","surName":"Alo","workLogs":[{"_id":ObjectId("596ce468798b61179c6442bc"),"day":1,"month":1,"year":2017,"timeEntrance":"8:00","lunchLeave":"12:00"

mongodb - 如何将 bson 和 json 文件导入 MongoDB?

我有以下来自https://github.com/Apress/def-guide-to-mongodb/tree/master/9781484211830/The%20Definitive%20Guide%20to%20MongoDB的bson和json文件$ls.aggregation.bsonaggregation.metadata.jsonmapreduce.bsonmapreduce.metadata.jsonstorage.bsontext.json如何将它们导入MongoDB?我尝试将它们中的每一个都导入为一个集合,但失败了:$mongorestore-dtest-cag