How can we perform "in" query on Elasticsearch in python, using elasticsearch_dsl?

Question

I have a list, id_list = [1, 3, 5, 7]

I need to fetch data from elasticsearch corresponding to the ids present in id_list, similar to id__in that we do for postgres.

I was trying to find a way using elasticsearch_dsl.Search(), but I am stuck at it. Any help with the code or relevant documentation will be very helpful.

Bhavya · Accepted Answer · 2021-05-26 08:16:39Z

1

You can use terms query to perform "in" query in elasticsearch

Try out the below query

{
  "query": {
    "terms": {
      "id_list": [
        1,
        3,
        5,
        7
      ]
    }
  }
}

answered May 26, 2021 at 8:16

Bhavya

16.2k3 gold badges23 silver badges52 bronze badges

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

2 Comments

Ayush Pallav Over a year ago

Thanks for your answer. Adding on to your point, for python we can use something like this s.query(query).filter('terms', id=[1, 3, 5, 7])

Bhavya Over a year ago

@uglyCoder yes you can include filter clause as well if you are not concerned about the scoring part, and you just want to know whether the id matched or not

Collectives™ on Stack Overflow

How can we perform "in" query on Elasticsearch in python, using elasticsearch_dsl?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related