Issue with elastic search when using nested query

Question

I have following query:

{
    "from": 0,
    "size": 20,
    "sort": {
        "prices_count": "desc"
    },
    "query": {
        "bool": {
            "must": [{
                "terms": {
                    "category_ids": ["3"]
                }
            }, {
                "terms": {
                    "manufacturer_id": ["5"]
                }
            }, {
                "range": {
                    "prices_count": {
                        "gte": 1
                    }
                }
            }]
        },
        "nested": {
            "bool": {
                "must": [{
                    "match": {
                        "specs.model": "iphone-6s"
                    }
                }]
            }
        }
    }
}

I get the following error:

Fatal error: Uncaught exception 'Elastica\Exception\ResponseException' with message 'failed to parse search source. expected field name but got [START_OBJECT]' in

If i leave just the nested part in the query, it works as expected.

Is it not possible to have and 'ordinary' and nested query in the same request, or am I just doing it wrong?

Val · Accepted Answer · 2016-12-01 07:20:20Z

1

You need to write it like this:

{
  "from": 0,
  "size": 20,
  "sort": {
    "prices_count": "desc"
  },
  "query": {
    "bool": {
      "must": [
        {
          "terms": {
            "category_ids": [
              "3"
            ]
          }
        },
        {
          "terms": {
            "manufacturer_id": [
              "5"
            ]
          }
        },
        {
          "range": {
            "prices_count": {
              "gte": 1
            }
          }
        },
        {
          "nested": {
            "path": "specs",
            "query": {
              "match": {
                "specs.model": "iphone-6s"
              }
            }
          }
        }
      ]
    }
  }
}

answered Dec 1, 2016 at 7:20

Val

218k14 gold badges377 silver badges384 bronze badges

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

1 Comment

galdikas Over a year ago

Hallelujah! Thanks! :)

Collectives™ on Stack Overflow

Issue with elastic search when using nested query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related