Elasticsearch query error - [or] query malformed, no start_object after query name

Question

Can somebody explain me please what is wrong with this query? I need to convert this generated query from Elasticsearch 2 to Elasticsearch 6. In ES2 this one works well, but in ES6 it throws me an error: [or] query malformed, no start_object after query name. I am lost in it. OR is necessary cause there could be more conditions than this one.

{
    "query": {
        "bool": {
            "filter": {
                "or": [
                    {
                        "nested": {
                            "path": "zalozcovia",
                            "query": {
                                "bool": {
                                    "filter": [
                                        {
                                            "match": {
                                                "zalozcovia.meno": "\u013dubo\u0161"
                                            }
                                        },
                                        {
                                            "match": {
                                                "zalozcovia.priezvisko": "Majgot"
                                            }
                                        },
                                        {
                                            "match": {
                                                "zalozcovia.mesto": "Trnava"
                                            }
                                        }
                                    ]
                                }
                            }
                        }
                    }
                ]
            }
        }
    },
    "size": 20,
    "sort": [
        {
            "rok": "desc"
        },
        {
            "cislo": "desc"
        }
    ]
}

Thanks.

RichieK · Accepted Answer · 2019-03-01 17:26:04Z

3

In ES6 there is afaik no "OR" Query (https://www.elastic.co/guide/en/elasticsearch/reference/6.4/query-dsl-or-query.html). You should use a bool query and use there the "should" Part (https://www.elastic.co/guide/en/elasticsearch/reference/6.4/query-dsl-bool-query.html).

{
    "query": {
        "bool": {
            "filter": [{
                "bool": {
                    "should": [{
                        "nested": {
                            "path": "zalozcovia",
                            "query": {
                                "bool": {
                                    "filter": [{
                                            "match": {
                                                "zalozcovia.meno": "\u013dubo\u0161"
                                            }
                                        },
                                        {
                                            "match": {
                                                "zalozcovia.priezvisko": "Majgot"
                                            }
                                        },
                                        {
                                            "match": {
                                                "zalozcovia.mesto": "Trnava"
                                            }
                                        }
                                    ]
                                }
                            }
                        }
                    }]
                }
            }]
        }
    },
    "size": 20,
    "sort": [{
            "rok": "desc"
        },
        {
            "cislo": "desc"
        }
    ]
}

edited Mar 1, 2019 at 17:26

answered Mar 1, 2019 at 16:31

RichieK

5547 silver badges21 bronze badges

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

13 Comments

Čamo Over a year ago

Yes I know but SHOULD throws me the same error only insead of [or] is [should]

dadoonet Over a year ago

Don't add or inside the should part.

Čamo Over a year ago

I dont. I change the OR to SHOULD.

RichieK Over a year ago

can you show your corrected query? at least the error somehow shows, that your syntax is still not applicable. i think you should get rid of the first filter and switch or to should.

Čamo Over a year ago

You removed FILTER level. I missed it. Without filter it works. But I am not sure if I can remove it from the query.

|

ibrahimozgon · Accepted Answer · 2019-03-01 16:44:19Z

2

Try changing "filter-or" with should

{
    "query": {
        "bool": {
              "should" : [
                    {
                        "nested": {
                            "path": "zalozcovia",
                            "query": {
                                "bool": {
                                    "filter": [
                                        {
                                            "match": {
                                                "zalozcovia.meno": "\u013dubo\u0161"
                                            }
                                        },
                                        {
                                            "match": {
                                                "zalozcovia.priezvisko": "Majgot"
                                            }
                                        },
                                        {
                                            "match": {
                                                "zalozcovia.mesto": "Trnava"
                                            }
                                        }
                                    ]
                                }
                            }
                        }
                    }
                ]
            }
    },
    "size": 20,
    "sort": [
        {
            "rok": "desc"
        },
        {
            "cislo": "desc"
        }
    ]
}

answered Mar 1, 2019 at 16:44

ibrahimozgon

1,1971 gold badge12 silver badges19 bronze badges

5 Comments

Čamo Over a year ago

Yes it works but I am not sure if I can remove Filter level from query. Filter should be little efficient cause it does not count a score. Am I right?

ibrahimozgon Over a year ago

I'm not sure sir, But in your query above, seems, it doesn't need filter with or :) You can check this answer for must and filter difference: stackoverflow.com/a/43349478/2057653

Čamo Over a year ago

I know but there could be more conditions than one.

ibrahimozgon Over a year ago

you can add each condition to should array ? I don't get what is wrong?

Čamo Over a year ago

Ok I have it. There should be one more BOOL level inside the FILTER. Thanks.

Collectives™ on Stack Overflow

Elasticsearch query error - [or] query malformed, no start_object after query name

2 Answers 2

13 Comments

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

13 Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related