Full Text Search (Partial Match)

Christian_Findlay · 2021-10-27T20:50:32.910Z

I am evaluating full-text search on Atlas. I need to know that MongoDB Atlas supports partial matching. I created a database on the free tier and the search index config appears in the console. I created an index as per the instructions. I need to confirm that if a field has “text” and I search for “text” that there is a match. I also need to confirm that it is using the Lucene engine.

image1536×234 14 KB

I can do searches but partial match does not work. I.e. searching for “text” yields a result, but “tex” yields nothig. I then saw this article and now I’m wondering if the free tier supports partial matching. Does it?

I tried creating a serverless instance but there is no config for searching there at all.

So, is it possible to do partial text matching on searches on the free tier? If not, what do I need to do to see this functionality? Which minimum level tier do I need?

Alternatively, is there a MongoDB docker image I can use that comes with Lucene search?

Christian_Findlay · 2021-10-27T20:53:54.877Z

Correction

Christian_Findlay:

I need to confirm that if a field has “text” and I search for “text” that there is a match.

Should be
I need to confirm that if a field has “text” and I search for “tex” that there is a match.

Christian_Findlay · 2021-10-27T20:59:05.893Z

I have also tried searching with tex* but this doesn’t yield results either.

Christian_Findlay · 2021-10-27T21:02:13.478Z

image1264×292 16.1 KB

Christian_Findlay · 2021-10-27T21:02:43.862Z

image1257×204 12.6 KB

Christian_Findlay · 2021-10-27T21:03:17.311Z

image1239×195 12.5 KB

Christian_Findlay · 2021-10-27T21:23:32.372Z

Perhaps I need the autocomplete operator? If so, how would I even do an autocomplete query through the portal? Do you I need to use the API client SDK for that?

Elle_Shwer · 2021-10-28T13:59:58.674Z

Hey there! Yes you can use the autocomplete operator - I would make sure it is also set up correctly in your index https://docs.atlas.mongodb.com/reference/atlas-search/index-definitions/#autocomplete (can set up using our visual index builder directions here) and then use the right query in either Compass Aggregation Builder, on the Atlas Collections tab in Aggregation Builder or in the Mongoshell

Let us know if you get it!

Philip_Braswell · 2022-02-09T20:01:33.428Z

You can use search with wildcard to achieve this. Once you’ve created a search index, you can do something like this:

db.collection.aggregate([{ $search: { wildcard: { query: '*tex*', path: { 'wildcard': '*' }, allowAnalyzedField: true }} } ]);

Pawan_Saxena · 2022-06-10T12:50:15.422Z

Beware !!!
Using this appraoch seems good. But it puts way too high load on your servers, CPU exhaustion, memory exhaustion becomes frequent if you have a decent amount of data.
Only index the fields you need and write the aggregation in a way which you think would actually be used.
For your use case :

regex and wildcards : https://www.mongodb.com/docs/atlas/atlas-search/regex/#std-label-regex-ref
Custom analyzers : https://www.mongodb.com/docs/atlas/atlas-search/analyzers/custom/

Hope it helps.

system · 2022-06-25T12:28:44.086Z

This topic was automatically closed 5 days after the last reply. New replies are no longer allowed.