ElasticSearch Nested types with List Inside the nested type

Question

Is it possible to have a Nested Type with List inside of it in ElasticSearch? An Example would be something of I was thinking is like this

{
  "name" : "Zach",
  "car" : [
    {
      "make" : "Saturn",
      "model" : "SL",
      "colors": ["Red","Blue","Green"]
     },
    {
      "make" : "Saturn",
      "model" : "Imprezza",
      "colors": ["Pink","Green"]
    }
  ]
}

How would I query such the FF?

1) I want to query all persons that their cars are "make" with "Saturn" and has colors of "Green"

2) I want to query all persons that their cars has colors of "Green" or "PINK"

So, did it solved your problem or not?

progrrammer
– progrrammer

2014-08-07 15:28:02 +00:00
Commented Aug 7, 2014 at 15:28 — progrrammer
– progrrammer, Commented Aug 7, 2014 at 15:28

Christian · Accepted Answer · 2014-08-06 15:36:25Z

1

Yes. Here's how I would do it:

Step 1. Set up mapping:

PUT /index_name
{
  "mappings": {
    "type_name": {
      "properties": {
        "name": {
          "type": "string"
        },
        "car": {
          "type": "nested",
          "properties": {
            "make": {
              "type": "string"
            },
            "model": {
              "type": "string"
            },
            "colors": {
              "type": "string"
            }
          }
        }
      }
    }
  }
}

Step 2. Populate the index:

PUT /index_name/type_name/1
{
  "name": "Zach",
  "car": [
    {
      "make": "Saturn",
      "model": "SL",
      "colors": [
        "Red",
        "Blue",
        "Green"
      ]
    },
    {
      "make": "Saturn",
      "model": "Imprezza",
      "colors": [
        "Pink",
        "Green"
      ]
    }
  ]
}

Step 3. Query the index. Note: You'll need to use the bool query in order to retrieve documents with multiple query parameters.

GET /index_name/type_name/_search
{
  "query": {
    "nested": {
      "path": "car",
      "query": {
        "bool": {
          "must": [
            {
              "match": {
                "make": "Saturn"
              }
            },
            {
              "match": {
                "colors": "Green"
              }
            }
          ]
        }
      }
    }
  }
}

edited Aug 6, 2014 at 15:36

answered Jul 2, 2014 at 2:11

Christian

865 bronze badges

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

10 Comments

user962206 Over a year ago

Question, why "car.colors.color": "Green" ? why not "car.colors" only?

Christian Over a year ago

Good question. I changed the colors property from an object to an array as described here. That should simplify things.

user962206 Over a year ago

Another question, why did you added an index on colors? "index_name": "tag" ?

Christian Over a year ago

You're right, it's not necessary. I removed it from the answer.

user962206 Over a year ago

why didn't also use a nested query when querying nested objects?

|

progrrammer · Accepted Answer · 2014-08-06 11:43:13Z

Yes, You can have array of nested documents.

Here is your solution.

Create index, put mapping and data.

PUT x3
PUT x3/x4/_mapping
{
   "x4": {
      "properties": {
         "name": {
            "type": "string"
         },
         "car": {
            "type": "nested",
            "properties": {
               "make": {
                  "type": "string",
                  "index": "not_analyzed"
               },
               "model": {
                  "type": "string",
                  "index": "not_analyzed"
               },
               "colors": {
                  "type": "string",
                  "index": "not_analyzed"
               }
            }
         }
      }
   }
}

PUT /x3/x4/1
{
  "name": "Zach",
  "car": [
    {
      "make": "Saturn",
      "model": "SL",
      "colors": [
        "Red",
        "Blue",
        "Green"
      ]
    },
    {
      "make": "Saturn",
      "model": "Imprezza",
      "colors": [
        "Pink",
        "Green"
      ]
    }
  ]
}

1) I want to query all persons that their cars are "make" with "Saturn" and has colors of "Green"

POST x3/x4/_search
{
    "filter": {
        "nested": {
           "path": "car",
           "filter": {
               "and": {
                  "filters": [
                     {
                         "term": {
                            "make":"Saturn"
                         }
                     },{
                         "term": {
                            "colors":"Green"
                         }
                     }
                  ]
               }
           }
        }
    }
}

2) I want to query all persons that their cars has colors of "Green" or "PINK"

POST x3/x4/_search
{
   "filter": {
      "nested": {
         "path": "car",
         "filter": {
            "terms": {
               "car.colors": [
                  "Green" , "Pink"
               ]
            }
         }
      }
   }
}

References:: nested filter, mapping , term filter

Hope this helps!!

Collectives™ on Stack Overflow

ElasticSearch Nested types with List Inside the nested type

2 Answers 2

10 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

10 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related