Method db.collection.distinct is not implemented.

[lala7573]

Hi, I'm using DataGrip with mongodb driver and faced error

Method db.collection.distinct is not implemented.

And found out it's really not implemented.
https://github.com/DataGrip/mongo-jdbc-driver/blob/master/src/main/java/com/dbschema/mongo/nashorn/JMongoCollection.java#L66

Is there any plan to support this? and why doesn't it work?

[kornilova203]

Hello @lala7573,
Soon we will change our methods implementation to mongodb-js/mongosh and most of the methods will be supported. I believe it will happen within 2 weeks.

Though distinct method is a bit tricky but I think I will be able to make it work

[kornilova203]

The problem is that MongoDB did not provide a way to execute shell scripts outside the command-line shell.
But with mongodb-js/mongosh it will be possible. I currently work on Java wrapper for it.

[alexander-alegre]

Using the latest of DataGrip (2021.1.3) the issue is still present. Any update?

[kornilova203]

Hello @alexander-alegre,
I'll check next week if I can fix this issue

[kornilova203]

Hi all!
Sorry that it took so much time to fix the issue
I've implemented distinct operation, it will be in MongoDB driver soon
mongodb-js/mongosh#1073

But there is a limitation unfortunately: all values should be of one type because Java driver for MongoDB requires you to specify type for value comparison. In my implementation I use type of the first value in a given field.
If there are different types, you'll see an error like Invalid numeric type, found: STRING.
Though you always can filter documents using second parameter in distinct function e.g. db.collection.distinct('color', {type: 'plane'})

[rahulroy9202]

Using the latest of DataGrip (2021.2.2) MongoDB Driver Version 1.12 the issue is still present. Any update? Thanks

[GilbertOstlethwaite]

DataGrip 2021.2.4 and the issue is still present

[kornilova203]

It works for me:

@rahulroy9202, could you please share a command that you run and an error that you get?

@GilbertOstlethwaite, you need to update driver. Go to data source connection page, choose Drivers and find MongoDB there:

[rahulroy9202]

Hi @kornilova203 I have updated to 2021.2.4 since and tried distinct. It works for me now. Thank You

[kornilova203]

@rahulroy9202,
Good!
For your information: usually you need to update drivers manually, they are not updated automatically with IDE updates.
It's because new drivers may have new bugs, and we want users to be aware of the fact that driver was changed.

[kornilova203]

Works as expected in driver v1.18.
If you still have any issues, please let me know here