如何在Python中编写包含Range与Match查询的Elasticsearch复合查询？

Got it, let's break down why your combined query is throwing an error and fix it step by step.

First, your individual range and match queries work because each uses a single top-level query type—the query field only contains one key (either range or match). When you try to stuff both directly under query, Elasticsearch throws an error because the query field can only accept one top-level query object, not multiple conflicting keys.

The solution is to use Elasticsearch's bool compound query, which is designed specifically to combine multiple query conditions with logical relationships (like "AND", "OR", etc.). For your use case (both conditions must be satisfied), we'll use the must array inside the bool query—this tells Elasticsearch that all queries in the array must match a document.

Here's the corrected code:

res = es.search(
    index="dummy",
    body={
        "from": 0,
        "size": 0,
        "query": {
            "bool": {
                "must": [
                    {"range": {"key": {"gte": "1000"}}},
                    {"match": {"word": "sky"}}
                ]
            }
        }
    }
)

Quick breakdown of the structure: #

• bool: Signals to Elasticsearch that we're combining multiple query conditions
• must: Acts like a logical "AND"—all queries in the array must match the document to be included in results
• Each entry in the must array is your original, working range and match queries, unchanged

If you ever need to adjust the logic later:

• Use should instead of must for a logical "OR" (documents need to match at least one condition)
• Use must_not to exclude documents that match a specific condition

内容的提问来源于stack exchange，提问作者Amogh Mishra