Mixing
Official MongoDB Scala Driver, aggregate count sum 1
up vote
-1
down vote
favorite
I am using official mongo scala driver: http://mongodb.github.io/mongo-scala-driver/.
I want to do query like:
db.test.aggregate([{"$group" : {_id:{name:"$name",details:"$details.id"}, count:{$sum:1}}}, {$sort:{"count":-1}} ])
so in scala code I am doing:
collectionDoc.aggregate(List(
group(Document("name" -> "$name", "details" -> "$details.id"), Accumulators.sum("count", "1")),
)).toFuture()
but in all results I see:
(count,BsonInt32{value=0}))
From mongo driver logs I see that its send:
{
"aggregate": "test",
"pipeline": [
{
"$group": {
"_id": {
"name": "$name",
"details": "$details.id"
},
"count": {
"$sum": "1"
}
}
}
],
"cursor": {
"batchSize": 2147483647
},
"$db": "my-db",
"$readPreference": {
"mode": "primaryPreferred"
}
}
If I do this query in mongo it counts those records fine..
Any idea how to solve this ?
Thanks!
mongodb scala mongodb-scala
asked 2 days ago
Baku
353214
add a comment |
up vote
-1
down vote
favorite
I am using official mongo scala driver: http://mongodb.github.io/mongo-scala-driver/.
I want to do query like:
db.test.aggregate([{"$group" : {_id:{name:"$name",details:"$details.id"}, count:{$sum:1}}}, {$sort:{"count":-1}} ])
so in scala code I am doing:
collectionDoc.aggregate(List(
group(Document("name" -> "$name", "details" -> "$details.id"), Accumulators.sum("count", "1")),
)).toFuture()
but in all results I see:
(count,BsonInt32{value=0}))
From mongo driver logs I see that its send:
{
"aggregate": "test",
"pipeline": [
{
"$group": {
"_id": {
"name": "$name",
"details": "$details.id"
},
"count": {
"$sum": "1"
}
}
}
],
"cursor": {
"batchSize": 2147483647
},
"$db": "my-db",
"$readPreference": {
"mode": "primaryPreferred"
}
}
If I do this query in mongo it counts those records fine..
Any idea how to solve this ?
Thanks!
mongodb scala mongodb-scala
asked 2 days ago
Baku
353214
add a comment |
up vote
-1
down vote
favorite
up vote
-1
down vote
favorite
I am using official mongo scala driver: http://mongodb.github.io/mongo-scala-driver/.
I want to do query like:
db.test.aggregate([{"$group" : {_id:{name:"$name",details:"$details.id"}, count:{$sum:1}}}, {$sort:{"count":-1}} ])
so in scala code I am doing:
collectionDoc.aggregate(List(
group(Document("name" -> "$name", "details" -> "$details.id"), Accumulators.sum("count", "1")),
)).toFuture()
but in all results I see:
(count,BsonInt32{value=0}))
From mongo driver logs I see that its send:
{
"aggregate": "test",
"pipeline": [
{
"$group": {
"_id": {
"name": "$name",
"details": "$details.id"
},
"count": {
"$sum": "1"
}
}
}
],
"cursor": {
"batchSize": 2147483647
},
"$db": "my-db",
"$readPreference": {
"mode": "primaryPreferred"
}
}
If I do this query in mongo it counts those records fine..
Any idea how to solve this ?
Thanks!
mongodb scala mongodb-scala
asked 2 days ago
Baku
353214
I am using official mongo scala driver: http://mongodb.github.io/mongo-scala-driver/.
I want to do query like:
db.test.aggregate([{"$group" : {_id:{name:"$name",details:"$details.id"}, count:{$sum:1}}}, {$sort:{"count":-1}} ])
so in scala code I am doing:
collectionDoc.aggregate(List(
group(Document("name" -> "$name", "details" -> "$details.id"), Accumulators.sum("count", "1")),
)).toFuture()
but in all results I see:
(count,BsonInt32{value=0}))
From mongo driver logs I see that its send:
{
"aggregate": "test",
"pipeline": [
{
"$group": {
"_id": {
"name": "$name",
"details": "$details.id"
},
"count": {
"$sum": "1"
}
}
}
],
"cursor": {
"batchSize": 2147483647
},
"$db": "my-db",
"$readPreference": {
"mode": "primaryPreferred"
}
}
If I do this query in mongo it counts those records fine..
Any idea how to solve this ?
Thanks!
mongodb scala mongodb-scala
mongodb scala mongodb-scala
asked 2 days ago
Baku
353214
asked 2 days ago
Baku
353214
edited 2 days ago
asked 2 days ago
Baku
353214
asked 2 days ago
Baku
353214
asked 2 days ago
Baku
353214
353214
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
Ah silly mistake.
Ive put in scala code "1" instead of 1.
I found the issue after setting profile level to 2, and compared both queries.
answered 2 days ago
Baku
353214
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
Ah silly mistake.
Ive put in scala code "1" instead of 1.
I found the issue after setting profile level to 2, and compared both queries.
answered 2 days ago
Baku
353214
add a comment |
up vote
0
down vote
Ah silly mistake.
Ive put in scala code "1" instead of 1.
I found the issue after setting profile level to 2, and compared both queries.
answered 2 days ago
Baku
353214
add a comment |
up vote
0
down vote
up vote
0
down vote
Ah silly mistake.
Ive put in scala code "1" instead of 1.
I found the issue after setting profile level to 2, and compared both queries.
answered 2 days ago
Baku
353214
Ah silly mistake.
Ive put in scala code "1" instead of 1.
I found the issue after setting profile level to 2, and compared both queries.
answered 2 days ago
Baku
353214
answered 2 days ago
Baku
353214
answered 2 days ago
Baku
353214
answered 2 days ago
Baku
353214
353214
add a comment |
add a comment |
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53373137%2fofficial-mongodb-scala-driver-aggregate-count-sum-1%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
