Elasticsearch: how to add "nested query" into (nested) filter

Question

My structure:

Person: type object.
Person.Cars: type nested.
Person.Cars.Radios: type nested.

I want to write a query that should find all person with:

Car X
Car year from 40 to 100
Radio in the car Y

 {
      "query": {
        "nested": {
          "path": "person.cars",
          "query": {
            "bool": {
              "filter": [
                {
                  "match": {
                    "person.cars.id": {
                      "query": "X"
                    }
                  }
                },
                {
                  "range": {
                    "person.cars.year": {
                      "from": 40,
                      "to": 100
                    }
                  }
                }
              ]
            },
            "nested": {
              "path": "person.cars.radios",
              "query": {
                "bool": {
                  "filter": [
                    {
                      "match": {
                        "person.cars.radios.id": {
                          "query": "Y"
                        }
                      }
                    }
                  ]
                }
              }
            }
          }
        }
      }
    }

My response:

{
    "error": {
        "root_cause": [
            {
                "type": "parsing_exception",
                "reason": "[bool] malformed query, expected [END_OBJECT] but found [FIELD_NAME]",
                "line": 26,
                "col": 5
            }
        ],
        "type": "parsing_exception",
        "reason": "[bool] malformed query, expected [END_OBJECT] but found [FIELD_NAME]",
        "line": 26,
        "col": 5
    },
    "status": 400
}

How to write query like this? I know that I have to move my second nested part, but I don't know how.

jordivador · Accepted Answer · 2018-05-28 08:05:20Z

1

I suggest you to add, your second nested query as a part of your first bool-filter.

 {
  "query": {
    "nested": {
      "path": "person.cars",
      "query": {
        "bool": {
          "filter": [
            {
              "match": {
                "person.cars.id": {
                  "query": "X"
                }
              }
            },
            {
              "range": {
                "person.cars.year": {
                  "from": 40,
                  "to": 100
                }
              }
            },
            {
              "nested": {
                "path": "person.cars.radios",
                "query": {
                  "bool": {
                    "filter": [
                      {
                        "match": {
                          "person.cars.radios.id": {
                            "query": "Y"
                          }
                        }
                      }
                    ]
                  }
                }
              }
            }
          ]
        }
      }
    }
  }
}

edited May 28, 2018 at 8:05

answered May 25, 2018 at 13:02

jordivador

1,09611 silver badges27 bronze badges

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

6 Comments

Adrian Klimczak Over a year ago

{ "error": { "root_cause": [ { "type": "parsing_exception", "reason": "no [query] registered for [query]", "line": 24, "col": 17 } ], "type": "parsing_exception", "reason": "no [query] registered for [query]", "line": 24, "col": 17 }, "status": 400 }

Adrian Klimczak Over a year ago

My version: 6.1.1

Adrian Klimczak Over a year ago

For version 6.2.4 the same problem. This is invalid query. :(

jordivador Over a year ago

@AdrianKlimczak Had no time until now to fix the query, glad to see that you've found the solution.

Adrian Klimczak Over a year ago

Can you edit your answer? After that I will accept your answer. :)

|

Adrian Klimczak · Accepted Answer · 2018-05-25 20:27:30Z

@jordivador you were so close.:) Just remove query key after range filter.

Good idea: use Java API - to check how to write a query.

{
  "query": {
    "nested": {
      "path": "person.cars",
      "query": {
        "bool": {
          "filter": [
            {
              "match": {
                "person.cars.id": {
                  "query": "X"
                }
              }
            },
            {
              "range": {
                "person.cars.year": {
                  "from": 40,
                  "to": 100
                }
              }
            },
            {
              "nested": {
                "path": "person.cars.radios",
                "query": {
                  "bool": {
                    "filter": [
                      {
                        "match": {
                          "person.cars.radios.id": {
                            "query": "Y"
                          }
                        }
                      }
                    ]
                  }
                }
              }
            }
          ]
        }
      }
    }
  }
}

Collectives™ on Stack Overflow

Elasticsearch: how to add "nested query" into (nested) filter

2 Answers 2

6 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related