I have created pipeline for lab1 nad executed but the number of documents returned are not correct. I am not sure what mistake I am doing. I want to correct that before proceeding to next section.
What is the number you are getting? Bigger or smaller?
If bigger your $match is not restrictive enough.
If small your $match is too restrictive.
If 0 you might be using wrong cluster, db, collection or fields.
bigger. I understand that there is problem but I don’t get where it is.
Most of the time people struggle with
- languages contains “English” and “Japanese”
by using an operator that is not restrictive enough.
yes, I guess problem is in language condition. I used in, and, all but no result. Not sure what should be used.
The $all operator is much more restrictive than the $in operator.
Another common error is typing mistakes in field names or values. As a clue to help pinpoint which part of the $match that is not enough restrictive. The queries for the different fields when executed alone should give:
languages query alone gives 533 documents
genres gives 35105
rated 3634
imdb.rating 15204
languages with genres 422
languages with rated 53
languages with imdb.rating 242
2 Likes
Many Thanks for your support.
It was spelling mistake in a value.