mongodb count num of distinct values per field/key

by

MongoDB has a distinct command which returns an array of distinct values for a field; you can check the length of the array for a count.

There is a shell db.collection.distinct() helper as well:

> db.countries.distinct('country');
[ "Spain", "England", "France", "Australia" ]

> db.countries.distinct('country').length
4

As noted in the MongoDB documentation:

Results must not be larger than the maximum BSON size (16MB). If your results exceed the maximum BSON size, use the aggregation pipeline to retrieve distinct values using the $group operator, as described in Retrieve Distinct Values with the Aggregation Pipeline.

More Related Contents:

  1. Retrieve only the queried element in an object array in MongoDB collection
  2. Update MongoDB field using value of another field
  3. Does MongoDB’s $in clause guarantee order
  4. $lookup on ObjectId’s in an array
  5. Return only matched sub-document elements within a nested array
  6. Converting string to date in mongodb
  7. Check if every element in array matches condition
  8. MongoDB nested lookup with 3 levels
  9. MongoDB Full and Partial Text Search
  10. Matching ObjectId to String for $graphLookup
  11. Mongodb Join on _id field from String to ObjectId
  12. exclude fields in $lookup aggregation
  13. How to get back the Original document back after aggregation
  14. Mongo sort on a calculated condition
  15. MongoDB sort documents by array elements
  16. MongoDB lookup when foreign field is an array of objects
  17. MongoDB: Calculate dwell time between every status value change
  18. MongoDB: how to parse date in 3.6 mongoDb version?
  19. Search on multiple collections in MongoDB
  20. Using stored JavaScript functions in the Aggregation pipeline, MapReduce or runCommand
  21. MongoDB – The argument to $size must be an Array, but was of type: EOO / missing
  22. convert iso date to timestamp in mongo query
  23. Remove Duplicates from MongoDB
  24. Using $slice operator to get last element of array
  25. How to access overall document count during arithmetic aggregation expression
  26. Mongodb aggregation pipeline how to limit a group push
  27. count array occurrences across all documents with mongo
  28. Mongodb concat int and string
  29. mongodb aggregate query isn’t returning proper sum on using $sum
  30. MongoDB aggregate within daily grouping [duplicate]

Leave a Comment