db.P2447653_reviews_c.aggregate([{ $group: {_id: {"reviewerID" : "reviewerID", count: {$sum: 1 }}}, $match:{"reviewTime":{$gt:1}}, $project : { "reviewerID":1, "reviewerName":1, "reviewTime":1}} ])
我不明白這個問題,我對 MongoDB 很陌生
錯誤:MongoServerError:管道階段規范物件必須只包含一個欄位。
我不知道還能嘗試什么。我完全被困住了。
uj5u.com熱心網友回復:
做一些格式化,你的查詢是這樣的:
db.P2447653_reviews_c.aggregate([
{
$group: { _id: { "reviewerID": "reviewerID", count: { $sum: 1 } } },
$match: { "reviewTime": { $gt: 1 } },
$project: { "reviewerID": 1, "reviewerName": 1, "reviewTime": 1 }
}
])
你錯過了一些括號,一定是這樣的:
db.P2447653_reviews_c.aggregate([
{
$group: {
_id: { "reviewerID": "$reviewerID" },
count: { $sum: 1 }
}
},
{ $match: { "reviewTime": { $gt: 1 } } },
{ $project: { "reviewerID": 1, "reviewerName": 1, "reviewTime": 1 } }
])
轉載請註明出處,本文鏈接:https://www.uj5u.com/qukuanlian/446742.html
