Boolean query on elastic search

Question

I am using boolean queries in elastic search. My queries is

curl -XGET 'localhost:9200/population/_search' -d '{
   "query":{
        "bool" : {
            "must" : {
                "term" : { "user" : "rahul" }
            },
            "filter": {
                "term" : { "message" : "dsi" }
            },
            "must_not" : {

                    "country" : "pakistan"

            },
            "should" : [
                {
                    "term" : { "country" : "india" }
                },
                {
                    "term" : { "state" : "karnataka" }
                }
            ],

            "minimum_should_match" : 1,
            "boost" : 1.0
        }}

    }'

where user ,state,country are field in my elastic search. but getting error.

    {"error":{"root_cause":[{"type":"query_parsing_exception","reason":"[_na] query malformed, no field after start_object","index":"population","line":13,"col":17}],"type":"search_phase_execution_exception","reason":"all shards failed","phase":"query","grouped":true,"failed_shards":[{"shard":0,"index":"population","node":"bECY7K9ORPSuLrXpL1DpDw","reason":{"type":"query_parsing_exception","reason":"[_na] query malformed, no field after start_object","index":"population","line":13,"col":17}}]},"status":400}

Val · Accepted Answer · 2016-05-16 14:40:32Z

4

Your bool/must_not clause is not correct, you're missing a term query

curl -XGET 'localhost:9200/population/_search' -d '{
   "query":{
        "bool" : {
            "must" : {
                "term" : { "user" : "rahul" }
            },
            "filter": {
                "term" : { "message" : "dsi" }
            },
            "must_not" : {
                "term": { "country" : "pakistan" }      <--- change this line
            },
            "should" : [
                {
                    "term" : { "country" : "india" }
                },
                {
                    "term" : { "state" : "karnataka" }
                }
            ],

            "minimum_should_match" : 1,
            "boost" : 1.0
        }}

    }'

edited May 16, 2016 at 14:40

answered May 16, 2016 at 14:30

Val

218k14 gold badges377 silver badges384 bronze badges

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

2 Comments

Raj aryan Over a year ago

plz,explain me what changes i need to do.

Val Over a year ago

you just have a single line to change. See my updated answer. "term": { "country" : "pakistan" } instead of just "country" : "pakistan"

Collectives™ on Stack Overflow

Boolean query on elastic search

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related