Elasticsearch - Bool query failed to parse search

Question

So I am attempting to use a bool query that checks a user's id against other user's blacklist, as well as removing users that a user has blacklisted in the results.

Each query works fine on its own, but not together. I was under the impression from the elasticsearch documentation that inside a bool query I could chain them with commas.

If someone could tell me where I'm going wrong, it'd be much appreciated.

client.search({
  index: 'firebase',
  type: 'user',
  size: 500,
  body: {
    "query": {
       "filtered" : {
           "query" : {
               "bool" : {
                   "must_not" : {
                     "terms": { "id": user.blacklist},
                     "term": { "blacklist": user.id}
                   }
               }
             },
             "filter": {
                "and": query
             }

       }
 }

}
}).then(function (resp) {
    var hits = resp.hits.hits;
    res.send(hits);

    console.log(hits);
}, function (err) {
    console.log(err);
    res.sendStatus(500);
});

Jeremy · Accepted Answer · 2016-01-07 21:17:49Z

2

You're almost there. Your must_not query should be an array of objects, instead of just an object:

"bool" : {
  "must_not" : [
    {"terms": { "id": user.blacklist}},
    {"term": { "blacklist": user.id}}
  ]
}

Don't forget the extra brackets around each of the term(s) searches.

In the ElasticSearch documentation, notice how the should clause in the example query is an array instead of an object since it has more than one sub-clause.

edited Jan 7, 2016 at 21:17

answered Jan 7, 2016 at 14:47

Jeremy

1,92015 silver badges21 bronze badges

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

3 Comments

K.B. Choi Over a year ago

Thanks man...one question though. user.blacklist is an array of id's, shouldn't that be a terms search in order to iterate through it to match against id?

Jettro Coenradie Over a year ago

You are right, terms in the way to go if you want to match multiple values.

Jeremy Over a year ago

Oops, you're right. I should have picked up on the fact that blacklist was an array and not a single value. I'll edit my answer.

Collectives™ on Stack Overflow

Elasticsearch - Bool query failed to parse search

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related