Django-Elasticsearch-DSL Nested Range Query

Question

I'm trying to implement the following Elasticsearch query using django-elasticsearch-dsl and am having some difficulty

Query

  {
   "query":{
      "nested":{
         "path":"ip_addresses",
         "query":{
            "bool":{
               "filter":[
                  {
                     "range":{
                        "ip_addresses.ip":{
                           "gte":"192.168.1.0",
                           "lte":"192.168.1.255"
                        }
                     }
                  }
               ]
            }
         }
      }
   }
}

Code

  def search_ip_range(self, start: str, end: str):
        range_query = Q('range', gte=start, lte=end)

        search = Search()
        search = search.query('nested', path='ip_addresses', query=range_query)

        try:
            response = search.execute()
            pprint("Found {} results".format(response.hits.total.value))

            for hit in response:
                pprint(hit.detail_url)
        except Exception as e:
            pprint('Search error: {}'.format(e))

Error

RequestError(400, 'parsing_exception', '[range] query does not support [gte]')

Jozef - Spatialized.io · Accepted Answer · 2021-02-17 22:08:14Z

2

As the author of elasticsearch-dsl-py says, you'll need to use nested filters. One option would be:

...

range_query = Q('range', ip_addresses__ip={'gte': start, 'lte': end})

search = Search()
search = search.query('nested', path='ip_addresses', query=Q('bool', filter=[range_query]))

pprint(search.to_dict())

...

You can leave out the Q(bool, filter= part but the range won't then be wrapped in the it:

search = search.query('nested', path='ip_addresses', query=range_query)

Keep in mind that if you do wrap it in the filter context, no scores will be calculated.

answered Feb 17, 2021 at 22:08

Jozef - Spatialized.io

17k4 gold badges29 silver badges79 bronze badges

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

Collectives™ on Stack Overflow

Django-Elasticsearch-DSL Nested Range Query

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