我在 cosmosDB 中有一個包含檔案的集合。如何使用 mongoDB 對每個欄位的不同值進行分組？
這是我的示例資料：
{
"_id" : ObjectId("61ba65af74cf385ee93ad2c8"),
"Car_brand":"A",
"Plate_number":"5",
"Model_year":"2015",
"Company":"Tesla Motors"
},
{
"_id" : ObjectId("61ba65af74cf385ee93ad2c9"),
"Car_brand":"B",
"Plate_number":"2",
"Model_year":"2021",
"Company":"Tesla Motors",
},
{
"_id" : ObjectId("61ba65af74cf385ee93ad2ca"),
"Car_brand":"B",
"Plate_number":"2",
"Model_year":"2011",
"Company":"Lamborghini",
}
預期的：
{
"Car_brand":["A","B"]
"Plate_number":["5","2"]
"Model_year":["2015","2021","2011"]
"Company":["Lamborghini","Tesla Motors"]
}
uj5u.com熱心網友回復：
選項1：這是在 mongoDB 中的操作，我想在 cosmosDB 中是類似的：
db.collection.aggregate([
{
$group: {
_id: null,
Car_brand: {
$push: "$Car_brand"
},
Plate_number: {
$push: "$Plate_number"
},
Model_year: {
$push: "$Model_year"
},
Company: {
$push: "$Company"
}
}
}
])
操場
選項2：稍后我確定您需要不同的值，這是一個示例：
db.collection.aggregate([
{
$group: {
_id: null,
Car_brand: {
$addToSet: "$Car_brand"
},
Plate_number: {
$addToSet: "$Plate_number"
},
Model_year: {
$addToSet: "$Model_year"
},
Company: {
$addToSet: "$Company"
}
}
}
])
游樂場2
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/438870.html