Skip to content

reverse.md

Latest commit

 

History

History
134 lines (104 loc) · 2.74 KB

reverse.md

File metadata and controls

134 lines (104 loc) · 2.74 KB

reverse

Description

The reverse command reverses the display order of search results. The same results are returned, but in reverse order.

Syntax

reverse

  • No parameters: The reverse command takes no arguments or options.

Note

The reverse command processes the entire dataset. If applied directly to millions of records, it will consume significant memory resources on the coordinating node. Users should only apply the reverse command to smaller datasets, typically after aggregation operations.

Example 1: Basic reverse operation

This example shows reversing the order of all documents.

source=accounts
| fields account_number, age
| reverse

Expected output:

fetched rows / total rows = 4/4
+----------------+-----+
| account_number | age |
|----------------+-----|
| 6              | 36  |
| 18             | 33  |
| 1              | 32  |
| 13             | 28  |
+----------------+-----+

Example 2: Reverse with sort

This example shows reversing results after sorting by age in ascending order, effectively giving descending order.

source=accounts
| sort age
| fields account_number, age
| reverse

Expected output:

fetched rows / total rows = 4/4
+----------------+-----+
| account_number | age |
|----------------+-----|
| 6              | 36  |
| 18             | 33  |
| 1              | 32  |
| 13             | 28  |
+----------------+-----+

Example 3: Reverse with head

This example shows using reverse with head to get the last 2 records from the original order.

source=accounts
| reverse
| head 2
| fields account_number, age

Expected output:

fetched rows / total rows = 2/2
+----------------+-----+
| account_number | age |
|----------------+-----|
| 6              | 36  |
| 18             | 33  |
+----------------+-----+

Example 4: Double reverse

This example shows that applying reverse twice returns to the original order.

source=accounts
| reverse
| reverse
| fields account_number, age

Expected output:

fetched rows / total rows = 4/4
+----------------+-----+
| account_number | age |
|----------------+-----|
| 13             | 28  |
| 1              | 32  |
| 18             | 33  |
| 6              | 36  |
+----------------+-----+

Example 5: Reverse with complex pipeline

This example shows reverse working with filtering and field selection.

source=accounts
| where age > 30
| fields account_number, age
| reverse

Expected output:

fetched rows / total rows = 3/3
+----------------+-----+
| account_number | age |
|----------------+-----|
| 6              | 36  |
| 18             | 33  |
| 1              | 32  |
+----------------+-----+