Elasticsearch: match arrays of nested objects

Question

The example is extracted from Elasticsearch reference: https://www.elastic.co/guide/en/elasticsearch/reference/5.3/nested.html

My index is similar to this. The only difference is user.first and user.last are keyword type so I can use filter on them.

PUT my_index
{
  "mappings": {
    "my_type": {
      "properties": {
        "user": {
          "type": "nested" 
        }
      }
    }
  }
}

PUT my_index/my_type/1
{
  "group" : "fans",
  "user" : [
    {
      "first" : "John",
      "last" :  "Smith"
    },
    {
      "first" : "Alice",
      "last" :  "White"
    }
  ]
}

What is the query I should use to get documents that match the above array (exactly two items, one item is John Smith, one item is Alice White) in two situations:

Order doesn't matter
Order matters

nxh · Accepted Answer · 2017-09-10 01:15:47Z

0

After searching, the best way to achieve Order doesn't matter is: indexing a Count field.

See: Elasticsearch Equal Exactly

The reason is:

In Elasticsearch, there is no dedicated array type. Any field can contain zero or more values by default, however, all values in the array must be of the same datatype.

answered Sep 10, 2017 at 1:15

nxh

1,0891 gold badge12 silver badges23 bronze badges

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

Collectives™ on Stack Overflow

Elasticsearch: match arrays of nested objects

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