Elasticsearch aggregation over numeric range field

Question

I have a field, location.vertical.depth.value, which is a float_range field. I'd like Elasticsearch to return the minimum lower bound for this field across all query results.

An example document might be:

{
    "location": {
        "vertical": {
            "depth": {
                "value": {
                    "gte": 42.0,
                    "lte": 64.0
                }
            }
        }
    }
}

This is my attempt:

"aggs": {
    "min_depth": { "min": { "field": "location.vertical.depth.value" } }
}

This throws an exception:

class org.elasticsearch.search.aggregations.support.ValuesSource$Range cannot be cast to class org.elasticsearch.search.aggregations.support.ValuesSource$Numeric

Interestingly though I can do something similar with a date_range field with "min_date": { "min": { "field": "date" } }.

recent version of elastic give a more clear message. But it's exactly the same "Field [duration_range] of type [integer_range] is not supported for aggregation [min]". To do this you have to keep the value itself and aggregate on it. or use a script — Jaycreation
– Jaycreation, Commented Sep 15, 2020 at 4:57

Jozef - Spatialized.io · Accepted Answer · 2020-09-15 14:22:56Z

1

min and max aggs on range data types are currently not supported. The alternative is a script, just like @Jaycreation suggested:

{
  "size": 0,
  "aggs": {
    "min_depth": {
      "min": {
        "script": {
          "source": "params._source.location.vertical.depth.value.gte;"
        }
      }
    }
  }
}

answered Sep 15, 2020 at 14:22

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

Elasticsearch aggregation over numeric range field

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