Skip to content

Instantly share code, notes, and snippets.

@3axap4eHko
Last active March 5, 2020 20:07
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save 3axap4eHko/33aedfb8563a758d16993ea7ef2c9ba1 to your computer and use it in GitHub Desktop.
Save 3axap4eHko/33aedfb8563a758d16993ea7ef2c9ba1 to your computer and use it in GitHub Desktop.
db.createCollection('a');
db.a.insertMany([
{ day: 'Monday', packages: 1000 },
{ day: 'Tuesday', packages: 100 },
{ day: 'Monday', packages: 1000 },
]);
db.a.createIndex({ day: 1 });
db.createCollection('b', { viewOn: 'a', pipeline: [
{
$group: {
_id: { day: '$day' },
packages: { $sum: '$packages' },
}
}
] });
db.b.find({ day: 'Monday' }).explain();
/*
The result is
{
"$group" : {
"_id" : {
"day" : "$day"
},
"packages" : {
"$sum" : "$packages"
}
}
},
{
"$match" : {
"day" : {
"$eq" : "Monday"
}
}
}
*/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment