eranation/gist:3241616

Created August 2, 2012 22:51

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/eranation/3241616.js"></script>
Save eranation/3241616 to your computer and use it in GitHub Desktop.

Download ZIP

MongoDB Aggregation Framework way for "select count (distinct fieldName) from someTable" for large collections

Raw

gistfile1.js

	//equivalent of "select count (distinct fieldName) from someTable"
	db.someCollection.aggregate([{ $group: { _id: "$fieldName"} },{ $group: { _id: 1, count: { $sum: 1 } } } ])

FedericoHeichou commented Apr 16, 2021

db.a.aggregate([{"$match": {"port": 80}}, {"$group": { "_id": "$ip"}}, {"$count": "count"}])

This seems cuter (I added a match too)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment