Multi-match query in Elasticsearch

Introduction

A multi-match query helps you search for a word or phrase in many places at once. It makes finding information faster and easier.

You want to search for a keyword in both the title and description of products.

You need to find documents where a phrase appears in either the author name or content.

You want to search multiple fields like name, tags, and comments for a user query.

You want to rank results based on matches in several fields together.

Syntax

Elasticsearch

{
  "multi_match": {
    "query": "search text",
    "fields": ["field1", "field2", "field3"]
  }
}

The query is the word or phrase you want to find.

The fields list tells Elasticsearch where to look.

Examples

Searches for the word "apple" in both the title and description fields.

Elasticsearch

{
  "multi_match": {
    "query": "apple",
    "fields": ["title", "description"]
  }
}

Searches for the exact phrase "fresh orange" in the name and tags fields.

Elasticsearch

{
  "multi_match": {
    "query": "fresh orange",
    "fields": ["name", "tags"],
    "type": "phrase"
  }
}

Searches for "banana" giving double importance to matches in the title field.

Elasticsearch

{
  "multi_match": {
    "query": "banana",
    "fields": ["title^2", "description"]
  }
}

Sample Program

This query looks for the word "coffee" in the title, summary, and content fields of documents.

Elasticsearch

{
  "query": {
    "multi_match": {
      "query": "coffee",
      "fields": ["title", "summary", "content"]
    }
  }
}

Important Notes

You can boost some fields by adding ^number after the field name to make matches there count more.

Use the type option to change how the query matches, like "phrase" for exact phrases.

Multi-match queries are great for simple searches across many fields without writing multiple queries.

Summary

Multi-match queries let you search many fields at once with one query.

You specify the search word or phrase and the fields to check.

You can control importance and matching style with extra options.

Practice

1. What is the main purpose of a multi-match query in Elasticsearch?

easy

A. To search multiple fields with a single query

B. To update multiple documents at once

C. To delete multiple indexes simultaneously

D. To create multiple indexes in one request

Solution

1. Step 1: Understand the multi-match query concept

   A multi-match query allows searching across several fields in one query, making it easier to find matches in different parts of documents.

2. Step 2: Compare with other options

   The other options describe operations like creating indexes, updating documents, or deleting indexes, which are not the purpose of multi-match queries.

3. Final Answer:

   To search multiple fields with a single query -> Option A

4. Quick Check:

   Multi-match = search multiple fields [OK]

Hint: Multi-match searches many fields at once [OK]

Common Mistakes:

• Confusing multi-match with update or delete operations
• Thinking it creates or deletes indexes
• Assuming it searches only one field

2. Which of the following is the correct syntax to perform a multi-match query searching for the word "apple" in fields "title" and "description"?

easy

A. { "multi_match": { "query": "apple", "fields": ["title", "description"] } }

B. { "match": { "query": "apple", "fields": ["title", "description"] } }

C. { "multi_match": { "fields": ["title", "description"] } }

D. { "multi_match": { "query": "apple" } }

Solution

1. Step 1: Identify required keys in multi-match query

   A multi-match query requires a "query" key with the search term and a "fields" key listing the fields to search.

2. Step 2: Check each option for correct syntax

   { "multi_match": { "query": "apple", "fields": ["title", "description"] } } correctly includes both "query" and "fields" keys. { "match": { "query": "apple", "fields": ["title", "description"] } } uses "match" instead of "multi_match". { "multi_match": { "fields": ["title", "description"] } } misses the "query" key. { "multi_match": { "query": "apple" } } misses the "fields" key.

3. Final Answer:

   { "multi_match": { "query": "apple", "fields": ["title", "description"] } } -> Option A

4. Quick Check:

   multi_match needs query and fields [OK]

Hint: multi_match needs both query and fields keys [OK]

Common Mistakes:

• Using 'match' instead of 'multi_match'
• Omitting the 'query' key
• Omitting the 'fields' key

3. Given this multi-match query, what will be the effect?

{
  "multi_match": {
    "query": "quick fox",
    "fields": ["title", "content"],
    "type": "phrase"
  }
}

medium

A. Searches only the title field for the phrase "quick fox"

B. Searches for documents containing "quick" or "fox" anywhere in title or content

C. Searches for documents where "quick fox" appears as a phrase in either title or content

D. Searches for documents with exact match "quick fox" in all fields

Solution

1. Step 1: Understand the 'type' parameter in multi-match

   The "type": "phrase" option makes the query look for the exact phrase "quick fox" in the specified fields.

2. Step 2: Check fields and matching behavior

   The fields are "title" and "content", so the phrase must appear in either field, not necessarily both.

3. Final Answer:

   Searches for documents where "quick fox" appears as a phrase in either title or content -> Option C

4. Quick Check:

   type phrase = exact phrase match in fields [OK]

Hint: type phrase means exact phrase search [OK]

Common Mistakes:

• Thinking it searches for words separately (not phrase)
• Assuming it searches only one field
• Believing it requires phrase in all fields

4. Identify the error in this multi-match query:

{
  "multi_match": {
    "query": "data",
    "fields": "title, description"
  }
}

medium

A. "query" should be an array of words

B. "fields" should be an array, not a string

C. "multi_match" should be "match"

D. "fields" should be omitted for multi-match

Solution

1. Step 1: Check the type of "fields" value

   The "fields" key must be an array of field names, not a single string with commas.

2. Step 2: Validate other keys

   The "query" key is correctly a string. "multi_match" is the correct query type. "fields" should not be omitted.

3. Final Answer:

   "fields" should be an array, not a string -> Option B

4. Quick Check:

   fields must be array, not comma string [OK]

Hint: Fields must be an array, not a comma string [OK]

Common Mistakes:

• Passing fields as a comma-separated string
• Changing multi_match to match incorrectly
• Thinking query must be an array

5. You want to search for the term "coffee" giving higher importance to the "title" field than "description" and "tags" fields. Which multi-match query correctly applies this weighting?

hard

A. { "multi_match": { "query": "coffee", "fields": ["title", "description", "tags"], "boost": 3 } }

B. { "multi_match": { "query": "coffee", "fields": ["title", "description^3", "tags"] } }

C. { "multi_match": { "query": "coffee", "fields": ["title", "description", "tags"], "type": "boost" } }

D. { "multi_match": { "query": "coffee", "fields": ["title^3", "description", "tags"] } }

Solution

1. Step 1: Understand field boosting syntax

   To give more importance to a field, add a caret (^) and a boost number after the field name, e.g., "title^3".

2. Step 2: Check each option for correct boosting

   { "multi_match": { "query": "coffee", "fields": ["title^3", "description", "tags"] } } boosts "title" by 3, others default. { "multi_match": { "query": "coffee", "fields": ["title", "description^3", "tags"] } } boosts "description" incorrectly. { "multi_match": { "query": "coffee", "fields": ["title", "description", "tags"], "boost": 3 } } tries to boost all fields equally with "boost" key, which is invalid here. { "multi_match": { "query": "coffee", "fields": ["title", "description", "tags"], "type": "boost" } } uses an invalid "type" value.

3. Final Answer:

   { "multi_match": { "query": "coffee", "fields": ["title^3", "description", "tags"] } } -> Option D

4. Quick Check:

   Use ^number to boost fields [OK]

Hint: Boost fields with ^number after field name [OK]

Common Mistakes:

• Boosting wrong field
• Using 'boost' key incorrectly
• Setting invalid 'type' value