Querying array of arrays in MongoDB

Question

I have a mongo collection which has an array of arrays (bigrams from a NLP process) that I'd like to be able to search, so for example;

{
    "sentence" : "will most likely be",
    "biGrams" : [["will","most"], ["most","likely"], ["likely", "be"]
},
{
    "sentence" : "likely most people use stackoverflow",
    "biGrams" : [["likely","most"], ["most","people"], ["people", "use"], ["use", "stackoverflow"]
}

What I'd like to be able to do is search through the biGram sub-doucment for a certain instance of one of these bigrams, e.g. search for all sentences that contain the bigram ["most","likely"].

I've tried this;

find({'biGrams':{$elemMatch: {$elemMatch:{$in:['most','likely']}} }})

But this obviously finds all cases with the word 'most' or 'likely' are present. And the order is important, i.e. I don't want to find docs with ['likely','most'] in this example.

Thanks in advance, I'm stumped....

Ack, being dumb. Simple; find({'biGrams':["likely", "most"]}) — Mike P
– Mike P, Commented Dec 5, 2013 at 17:12

drmirror · Accepted Answer · 2013-12-05 17:14:03Z

1

How about

find({"biGrams":["most","likely"]})

Searching on a particular field "unwinds" one level of arrays in that field, and searching for a particular array should be a binary match on that array.

answered Dec 5, 2013 at 17:14

drmirror

3,76028 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Querying array of arrays in MongoDB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related