how to fetch nested object in elastic search?

Question

How can i fetch nested object in elastic search ? 

{
            "_index": "userinfo",
            "_type": "userdetails",
            "_id": "2",
            "_score": 1,
            "_source": {
               "id": "2",
               "name": "Robert Mark",
               "age": 42,
               "email": "[email protected]",
               "userType": {
                  "id": "3",
                  "type": "End User"
               },
               "hobbies": [
                  {
                     "id": "3",
                     "description": "Writing Books"
                  },
                  {
                     "id": "4",
                     "description": "Gardening"
                  }
               ]
            }
         }

This is my json structure i want to fetch all the records where description under hobbies are "Gardening" .

I am new to elastic search please help me for this if any one knows .

"description": "Gardening"

pickypg · Accepted Answer · 2016-07-01 00:20:48Z

1

This is your query:

{
  "query": {
    "nested": {
      "path": "hobbies",
      "query": {
        "match": {
          "hobbies.description": "Gardening"
        }
      }
    }
  }
}

edited Jul 1, 2016 at 0:20

pickypg

22.4k5 gold badges75 silver badges85 bronze badges

answered Jun 30, 2016 at 17:31

israelst

1,0829 silver badges7 bronze badges

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

Comments

pickypg · Accepted Answer · 2016-07-01 00:20:08Z

0

israelst is correct if you precreated a nested mapping type for your hobbies object. By default though, it uses object instead of `nested.

{
  "query" : {
    "match" : {
      "hobbies.description" : "Gardening"
    }
  }
}

Note that the queries are practically the same and, in fact, my example is a subset of the nested version.

answered Jul 1, 2016 at 0:20

pickypg

22.4k5 gold badges75 silver badges85 bronze badges

1 Comment

bhanwar rathore Over a year ago

My Hobby Object is already mapped as type nested but still your solution is not working @Field(type = FieldType.Nested) private List<Hobby> hobbies; anyway thanks for the answer.

Collectives™ on Stack Overflow

how to fetch nested object in elastic search?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related