Finding distinct from collections in mongodb

3.8k Views Asked by At

Our previous implementation for finding distinct elements from a collection used to be :

List<String> names = mongoClient.getDB(dbName).getCollection(collectionName).distinct(NAME_KEY);

Trying to upgrade this into the current implementation with mongo 3.3.0+ as tried is :

List<String> names = mongoClient.getDatabase(dbName)
                        .getCollection(collectionName, TDocType.class)
                        .distinct(NAME_KEY, String.class); // compile error - required Class<TResult> 

Have also given a try to

.distinct(NAME_KEY, TDocType.class)  // doesn't work                      

What shall be the target type of the iterable in this case?

Edit - The question is not a duplicate of Get distinct records values since the implementation has changed over the upgrade of mongodb-java-driver.

2

There are 2 best solutions below

2
s7vr On BEST ANSWER

Improved answer from @jyemin

List<String> list = mongoClient.getDatabase(dbName)
                .getCollection(collectionName, TDocType.class)
                .distinct(NAME_KEY, String.class)
                .into(new ArrayList<>()); 

Original answer

You can try something like this.

DistinctIterable<String> iterable = mongoClient.getDatabase(dbName).
            .getCollection(collectionName, TDocType.class).distinct(NAME_KEY, String.class);
MongoCursor<String> cursor = iterable.iterator();
List<String> list = new ArrayList<>();
while (cursor.hasNext()) {
    list.add(cursor.next());
 }
0
boly38 On

for those who already have org.codehaus.groovy:groovy in their deps :

// import static org.codehaus.groovy.runtime.DefaultGroovyMethods.toSet;.
toSet(distinctIterable);

Example

DistinctIterable<String> distinctIterable = getCollection()
            .distinct(FIELD_ID, query.getQueryObject(), String.class);
return toSet(distinctIterable);