Why compound queries combine conditions in Elasticsearch - See It in Action

Why compound queries combine conditions

📖 Scenario: You are working with a collection of books in an Elasticsearch index. You want to find books that match multiple conditions, such as the author and the year of publication.

🎯 Goal: Build a compound Elasticsearch query that combines multiple conditions to find books by a specific author published after a certain year.

📋 What You'll Learn

Create a JSON object called query with a bool compound query

Add a must condition to match the author name exactly

Add a filter condition to include only books published after 2010

Print the final query JSON object

💡 Why This Matters

🌍 Real World

Compound queries are used in search engines to find documents that match several conditions at once, like filtering products by brand and price.

💼 Career

Understanding compound queries is essential for roles involving search engine development, data retrieval, and building advanced filters in Elasticsearch.

1

DATA SETUP: Create the base query structure

Create a JSON object called query with a bool key containing empty must and filter lists.

Elasticsearch

query = {
    "bool": {
        "must": [],
        "filter": []
    }
}
# Your code here

Hint

Use a dictionary with keys bool, must, and filter as empty lists.

2

CONFIGURATION: Add a must condition for author

Add a match condition inside the must list of query["bool"] to match the author name "J.K. Rowling".

Elasticsearch

query = {
    "bool": {
        "must": [],
        "filter": []
    }
}
# Add a match condition for author inside must

Hint

Append a dictionary with match key for author inside the must list.

3

CORE LOGIC: Add a filter condition for publication year

Add a range condition inside the filter list of query["bool"] to include only books published after 2010.

Elasticsearch

query = {
    "bool": {
        "must": [
            {"match": {"author": "J.K. Rowling"}}
        ],
        "filter": []
    }
}
# Add a range condition for publication year inside filter

Hint

Append a dictionary with range key for publication_year greater than 2010 inside the filter list.

4

OUTPUT: Print the final query JSON

Print the query JSON object using print(query).

Elasticsearch

query = {
    "bool": {
        "must": [
            {"match": {"author": "J.K. Rowling"}}
        ],
        "filter": [
            {"range": {"publication_year": {"gt": 2010}}}
        ]
    }
}
# Print the query

Hint

Use print(query) to display the final JSON object.

Practice

1. What is the main purpose of using compound queries in Elasticsearch?

easy

A. To combine multiple conditions for more precise search results

B. To speed up the indexing process

C. To delete documents from the index

D. To create new indexes automatically

Solution

1. Step 1: Understand the role of compound queries

   Compound queries allow combining several conditions to refine search results.

2. Step 2: Identify the main benefit

   Combining conditions helps find exactly what you want by mixing rules.

3. Final Answer:

   To combine multiple conditions for more precise search results -> Option A

4. Quick Check:

   Compound queries = combine conditions [OK]

Hint: Compound queries mix conditions to narrow search [OK]

Common Mistakes:

• Thinking compound queries speed up indexing
• Confusing compound queries with index creation
• Believing compound queries delete documents

2. Which of the following is the correct syntax to combine conditions using a bool query in Elasticsearch?

easy

A. {"bool": {"must": [{"match": {"field": "value"}}]}}

B. {"combine": {"and": [{"match": {"field": "value"}}]}}

C. {"query": {"combine": [{"match": {"field": "value"}}]}}

D. {"bool": {"combine": [{"match": {"field": "value"}}]}}

Solution

1. Step 1: Recall the correct bool query syntax

   The bool query uses keys like must, should, must_not, and filter inside a bool object.

2. Step 2: Match the syntax with options

   {"bool": {"must": [{"match": {"field": "value"}}]}} correctly uses "bool" with "must" and a match clause.

3. Final Answer:

   {"bool": {"must": [{"match": {"field": "value"}}]}} -> Option A

4. Quick Check:

   Bool query uses must inside bool [OK]

Hint: Bool query uses must, should, must_not, filter keys [OK]

Common Mistakes:

• Using 'combine' instead of 'bool'
• Placing conditions outside bool
• Wrong nesting of match inside combine

3. Given this Elasticsearch bool query, what documents will it match?

{"bool": {"must": [{"match": {"title": "apple"}}], "must_not": [{"match": {"status": "sold"}}]}}

medium

A. Documents with title 'apple' and status 'sold'

B. Documents with title containing 'apple' and status not 'sold'

C. Documents with title 'apple' or status 'sold'

D. Documents with status 'sold' only

Solution

1. Step 1: Analyze the must clause

   The must clause requires the title field to match 'apple'.

2. Step 2: Analyze the must_not clause

   The must_not clause excludes documents where status matches 'sold'.

3. Final Answer:

   Documents with title containing 'apple' and status not 'sold' -> Option B

4. Quick Check:

   Must + must_not = include and exclude [OK]

Hint: Must means include; must_not means exclude [OK]

Common Mistakes:

• Confusing must_not as must
• Thinking must_not includes documents
• Mixing OR logic instead of AND

4. Identify the error in this Elasticsearch bool query:

{"bool": {"must": {"match": {"name": "john"}}, "should": [{"term": {"age": 30}}]}}

medium

A. "match" is not valid inside "must"

B. "should" cannot be used with "must"

C. "must" should be an array, not a single object

D. The query is correct as is

Solution

1. Step 1: Check the structure of must clause

   The must clause expects an array of conditions, but here it is a single object.

2. Step 2: Verify should clause usage

   The should clause is correctly an array, so no error there.

3. Final Answer:

   "must" should be an array, not a single object -> Option C

4. Quick Check:

   Must requires array of conditions [OK]

Hint: Must and should clauses expect arrays [OK]

Common Mistakes:

• Using object instead of array for must
• Thinking should can't be with must
• Misplacing match inside must

5. You want to find documents where the field "category" is "books" and either "author" is "Alice" or "year" is 2020, but exclude those with "status" as "archived". Which bool query correctly combines these conditions?

hard

A. {"bool": {"should": [{"term": {"category": "books"}}, {"term": {"author": "Alice"}}, {"term": {"year": 2020}}], "must_not": [{"term": {"status": "archived"}}]}}

B. {"bool": {"must": [{"term": {"category": "books"}}, {"term": {"author": "Alice"}}], "must_not": [{"term": {"status": "archived"}}]}}

C. {"bool": {"filter": [{"term": {"category": "books"}}], "must": [{"term": {"author": "Alice"}}, {"term": {"year": 2020}}], "must_not": [{"term": {"status": "archived"}}]}}

D. {"bool": {"must": [{"term": {"category": "books"}}], "should": [{"term": {"author": "Alice"}}, {"term": {"year": 2020}}], "must_not": [{"term": {"status": "archived"}}]}}

Solution

1. Step 1: Identify the required conditions

   Must have category = books, should have author = Alice or year = 2020, and must_not have status = archived.

2. Step 2: Match conditions to bool clauses

   Category is mandatory (must), author or year is optional but at least one (should), and status excluded (must_not).

3. Final Answer:

   {"bool": {"must": [{"term": {"category": "books"}}], "should": [{"term": {"author": "Alice"}}, {"term": {"year": 2020}}], "must_not": [{"term": {"status": "archived"}}]}} -> Option D

4. Quick Check:

   Must + should + must_not combined correctly [OK]

Hint: Must = required, should = optional OR, must_not = exclude [OK]

Common Mistakes:

• Putting author in must instead of should
• Using filter instead of must for category
• Putting all conditions in should