Range query for long type in aws elasticsearch

Question

I am trying to query an elasticsearch index in AWS to get all entries with a mass attribute greater than 1000, the datatype for the attribute is Long.

I found the range query and have tried that (see example below) but it's returning nothing but when I use other queries they return attributes with mass greater than 1000 so they're definitely in the index.

This is the Range query I'm trying:

{
  "method": "POST",
  "index": "users",
  "type": "user",
  "path": "_search?filter_path=filter",
  "body": {
    "size": 20,
    "from": 0,
    "query": {
        "bool": {
            "must":[{
                "range": {
                  "mass": {
                    "gte": 1000
                  }
                }
            }]
        }

    }
  }
}

I'm not getting any error messages, just zero hits.

Are there more bool clauses under the bool element or why do you put that single range query inside a boolean query? — apt-get_install_skill, Sep 04 '19 at 19:18
There aren't, I've tried without the bool (just having the range part) and that didn't work either — Liam Sutton, Sep 05 '19 at 08:18
For me it looks like you are using the wrong HTTP verb. Use **GET** instead of POST. — apt-get_install_skill, Sep 05 '19 at 08:51
Remove the *filter_path* parameter. With that parameter you control what should be included in the response. — apt-get_install_skill, Sep 05 '19 at 09:23
Yes! That's working now, do you know of anywhere I can find details of this path parameter for future reference? — Liam Sutton, Sep 05 '19 at 09:48

score 1 · Accepted Answer · answered Sep 05 '19 at 09:54

So the problem that's causing to get you zero hits is the filter_path parameter you specify in

"path": "_search?filter_path=filter"

As stated in the official documentation the filter_path parameter is part of the common options regarding the REST API's. That means you can always add that parameter.

With Response Filtering you can reduce the response returned by Elasticsearch. Since you defined

_search?filter_path=filter

you probably get zero hits because there is no filter-element that can be returned.

Range query for long type in aws elasticsearch

1 Answers1