Store multiple ranges (of integer values) in the same field

[elastic_guy (guy)]

Hi,
I am interested with the best way of storing multiple ranges in the same field (or any other better way for storing multiple ranges).

for example,
I have an object type A, that should hold the following data:

A:

• name
• RangesFieldA: [1-2, 5, 7, 22-29]
• RangedFieldB: [2, 4-6].

then, I would like to query the objects of type A, by asking - give me all the objects of type A that range (x-y) contained in 'RangesFieldA' field.

now, I saw that there exist a range type, but I couldn't find if it's support multiple ranges?

Range datatypes | Elasticsearch Reference [5.6] | Elastic

I am currently using ES 5.6, and in the near future, we are upgrading to 6+ if it matters..

I am also interested to know, if your answer changes if A is a nested object inside another document..

Thanks

[Ignacio_Vera]

Yes, this is possible (at least in 6.x but I believe that is as well possible in your version), you just need to send your ranges as an array, for example:

PUT range_index
{
  "mappings": {
    "_doc": {
      "properties": {
        "int_range": {
          "type": "integer_range"
        }
      }
    }
  }
}


PUT range_index/_doc/1
{
  "int_range" : [{ 
    "gte" : 10,
    "lte" : 20
  },
  { 
    "gte" : 30,
    "lte" : 40
  }]
}

[Ignacio_Vera]

And it should apply to nested field as well.