Elasticsearch Must on list object

Question

I am using Elastic 6.0 .My kibana query is as below

  "bool": {
       "must": [
          {
           "match": {
             "relationships.relation": {
               "query": "spouse"
            }
      }
    },
    {
      "match": {
        "relationships.first_name": {
          "query": "james"
        }
      }
    },
    {
      "match": {
        "relationships.last_name": {
          "query": "smith"
        }
      }
    }
  ]
}

which gives me results as

    1.    "relationships": [
        {
          "first_name": "John",
          "last_name": "Heafner",
          "relation": "Father"
        },
        {
          "first_name": "Mary",
          "last_name": "Dellinger",
          "relation": "Mother"
        },
        {
          "first_name": "James S.",
          "last_name": "Smith",
          "relation": "Spouse"
        }
      ]

    2. "relationships": [
        {
          "first_name": "James",
          "last_name": "Hickey",
          "relation": "Father"
        },
        {
          "first_name": "Mary",
          "last_name": "Raftery",
          "relation": "Mother"
        },
        {
          "first_name": "Richard",
          "last_name": "Smith",
          "relation": "Spouse"
        }
      ]

I want only 1st result as it contains exact match based on my query
{ "first_name": "James S.", "last_name": "Smith", "relation": "Spouse" } I have tried term query but it is giving same results as above. Any suggestion would be of much help.

Russ Cam · Accepted Answer · 2018-05-30 10:13:57Z

1

This sounds like you have relationships mapped as an object type. For this to work as you expect, relationships needs to be mapped as a nested type and you should use nested queries to query fields of the nested objects.

answered May 30, 2018 at 10:13

Russ Cam

126k34 gold badges211 silver badges275 bronze badges

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

2 Comments

Sushil Over a year ago

Is there any other option as above solution means I need to change existing mapping

Russ Cam Over a year ago

No other option I'm afraid. The easiest way to remedy may be to use the Reindex API to reindex documents into a new index that has the nested mapping for relationships configured.

Collectives™ on Stack Overflow

Elasticsearch Must on list object

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related