Elasticsearch - Python client - How to match on multiple fields?

Question

I'm trying to match on more than one field when querying an ES server via the Python API. But can't figure out the syntax within Python:

I've tried;

res = es.search(index="pyats", doc_type="router_show", body={"query": {"match": {"name": "mark"} AND {"age": "21"}}}, size=1000)

and

res = es.search(index="pyats", doc_type="router_show", body={"query": {"match_all": {"name": "mark"} AND {"age": "21"}}}, size=1000)

and

res = es.search(index="pyats", doc_type="router_show", body={"query": {"match": {"name": "mark"}}, {"match": {"age": "21"}}}, size=1000)

Any advice would be greatly appreciated. None, seem to be working.

harshil9968 · Accepted Answer · 2016-12-05 17:28:34Z

2

Please make sure that age field is of the type integer or string. The keyword which will solve your problem is must.

{
    "query": {
        "constant_score" : {
            "filter" : {
                 "bool" : {
                    "must" : [
                        { "term" : { "age" : 21 } }, 
                        { "term" : { "name" : "mark" } } 
                    ]
                }
            }
        }
    }
}

answered Dec 5, 2016 at 17:28

harshil9968

3,2441 gold badge18 silver badges27 bronze badges

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

Collectives™ on Stack Overflow

Elasticsearch - Python client - How to match on multiple fields?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related