Sorting results in Elasticsearch - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the purpose of sorting results in Elasticsearch?

Sorting results in Elasticsearch arranges the search hits in a specific order based on one or more fields, such as date, relevance score, or numeric values, to help users find the most relevant or desired documents first.

beginner

How do you specify sorting by a field in an Elasticsearch query?

You add a sort section in the query JSON, specifying the field name and the order (asc for ascending or desc for descending). For example:

{ "sort": [{ "price": { "order": "asc" }}]}

intermediate

What happens if you sort by a field that has missing values in some documents?

Elasticsearch allows you to control how missing values are handled during sorting using the missing parameter. You can place missing values first, last, or assign a specific value to treat them consistently.

intermediate

Can you sort by multiple fields in Elasticsearch? How?

Yes, you can sort by multiple fields by providing an array of sort criteria. Elasticsearch sorts by the first field, then breaks ties using the second field, and so on. Example:

{ "sort": [ { "date": { "order": "desc" } }, { "price": { "order": "asc" } } ] }

beginner

What is the default sorting order if you do not specify a sort in Elasticsearch?

By default, Elasticsearch sorts results by relevance score in descending order, showing the most relevant documents first based on the query.

In Elasticsearch, how do you sort results by a field named 'age' in descending order?

A { "sort": [{ "age": { "order": "desc" }}] }

B { "sort": [{ "age": "asc" }] }

C { "order": "desc", "field": "age" }

D { "sort": "age desc" }

The correct syntax uses the 'sort' array with the field name and an 'order' key specifying 'desc' for descending.

What is the default sorting order in Elasticsearch if no sort is specified?

A By document ID ascending

B By relevance score descending

C By date ascending

D By field alphabetical order

Elasticsearch sorts by relevance score descending by default to show the most relevant documents first.

How can you handle documents with missing values when sorting in Elasticsearch?

A Elasticsearch ignores documents with missing values

B You cannot sort if any document has missing values

C Use the 'missing' parameter to specify placement or a default value

D Missing values are always treated as zero

The 'missing' parameter lets you control where documents with missing values appear in the sorted results.

Which of the following is the correct way to sort by multiple fields in Elasticsearch?

A { "sort": { "price": "asc", "date": "desc" } }

B { "sort": [ "price asc", "date desc" ] }

C { "sort": "price asc, date desc" }

D { "sort": [ { "price": { "order": "asc" } }, { "date": { "order": "desc" } } ] }

Sorting by multiple fields requires an array of objects with each field and order specified.

If you want to sort results by a text field, what must you consider in Elasticsearch?

A Text fields must be keyword or have a keyword subfield to be sortable

B Text fields can be sorted directly without any changes

C Text fields are sorted by their length automatically

D Sorting text fields is not supported in Elasticsearch

Text fields are analyzed and not directly sortable; you must use a keyword subfield or a non-analyzed field for sorting.

Explain how to sort search results by multiple fields in Elasticsearch and why you might want to do this.

Think about sorting first by one criterion, then by another to organize results better.

Describe how Elasticsearch handles missing values when sorting and how you can control their placement.

Consider what happens if some documents don't have the field you sort by.

Practice

1. What does the sort parameter do in an Elasticsearch query?

easy

A. It arranges the search results in a specified order.

B. It filters the search results based on a condition.

C. It changes the index mapping settings.

D. It deletes documents from the index.

Solution

1. Step 1: Understand the purpose of sort

   The sort parameter is used to order search results by a field in ascending or descending order.

2. Step 2: Differentiate from other parameters

   Filtering narrows results, mapping changes structure, and deleting removes data, none of which are sorting.

3. Final Answer:

   It arranges the search results in a specified order. -> Option A

4. Quick Check:

   Sorting = arranging results [OK]

Hint: Sort means order your results by a field [OK]

Common Mistakes:

• Confusing sorting with filtering
• Thinking sort deletes or changes data
• Mixing sort with index settings

2. Which of the following is the correct syntax to sort results by the field price in descending order?

easy

A. "sort": [{"price": "desc"}]

B. "sort": {"price": "descending"}

C. "sort": ["price:desc"]

D. "sort": [{"price": "down"}]

Solution

1. Step 1: Check Elasticsearch sort syntax

   Sorting uses an array of objects with field name and order as "asc" or "desc" strings.

2. Step 2: Validate each option

   "sort": [{"price": "desc"}] uses correct JSON array and "desc" keyword. Others use invalid keywords or formats.

3. Final Answer:

   "sort": [{"price": "desc"}] -> Option A

4. Quick Check:

   Correct syntax uses array and "desc" [OK]

Hint: Use array with field and "asc" or "desc" strings [OK]

Common Mistakes:

• Using wrong keywords like "descending" or "down"
• Not using an array for sort
• Incorrect JSON object structure

3. Given this Elasticsearch query snippet, what is the order of the returned documents by age?

{
  "sort": [{"age": "asc"}]
}

medium

A. Documents are sorted from oldest to youngest.

B. Documents are sorted alphabetically by age.

C. Documents are sorted randomly.

D. Documents are sorted from youngest to oldest.

Solution

1. Step 1: Understand the meaning of "asc" in sorting

   "asc" means ascending order, so smaller values come first.

2. Step 2: Apply to the field "age"

   Sorting by age ascending means documents with lower age values appear before higher ones.

3. Final Answer:

   Documents are sorted from youngest to oldest. -> Option D

4. Quick Check:

   "asc" = ascending = smallest to largest [OK]

Hint: "asc" means smallest to largest values [OK]

Common Mistakes:

• Confusing "asc" with descending order
• Thinking sorting is random
• Assuming alphabetical sort on numbers

4. Identify the error in this Elasticsearch sort snippet:

{
  "sort": {"date": "asc"}
}

medium

A. Sort cannot be used with date fields.

B. Sort must be an array, not a single object.

C. Field name "date" must be inside quotes.

D. The order "asc" is invalid; should be "ascending".

Solution

1. Step 1: Check the required structure for sort

   Sort expects an array of objects, even if sorting by one field.

2. Step 2: Analyze the given snippet

   The snippet uses an object directly, missing the array brackets [].

3. Final Answer:

   Sort must be an array, not a single object. -> Option B

4. Quick Check:

   Sort = array of objects [OK]

Hint: Sort always uses an array, even for one field [OK]

Common Mistakes:

• Using object instead of array for sort
• Wrong order keywords like "ascending"
• Thinking sort can't be used on dates

5. You want to sort search results first by category alphabetically ascending, then by price descending. Which is the correct sort clause?

hard

A. "sort": {"category": "asc", "price": "desc"}

B. "sort": [{"price": "desc"}, {"category": "asc"}]

C. "sort": [{"category": "asc"}, {"price": "desc"}]

D. "sort": [{"category": "desc"}, {"price": "asc"}]

Solution

1. Step 1: Understand multi-level sorting order

   Sorting applies fields in order: first field sorts primary, second field breaks ties.

2. Step 2: Match required order

   First by category ascending, then by price descending means category asc first, price desc second.

3. Step 3: Validate syntax

   Sort must be an array of objects with field and order pairs.

4. Final Answer:

   "sort": [{"category": "asc"}, {"price": "desc"}] -> Option C

5. Quick Check:

   Primary asc category, secondary desc price [OK]

Hint: List sort fields in order inside array [OK]

Common Mistakes:

• Reversing sort order of fields
• Using object instead of array for multiple fields
• Mixing ascending and descending incorrectly