rare command - Amazon OpenSearch Service

rare command

Note

To see which AWS data source integrations support this PPL command, see Commands.

Use the rare command to find the least common tuple of values of all fields in the field list.

Note

A maximum of 10 results is returned for each distinct tuple of values of the group-by fields.

Syntax

Use the following syntax:

rare [N] <field-list> [by-clause] rare_approx [N] <field-list> [by-clause]
field-list
  • Mandatory.

  • A comma-delimited list of field names.

by-clause
  • Optional.

  • One or more fields to group the results by.

N
  • The number of results to return.

  • Default: 10

rare_approx
Example 1: Find the least common values in a field

The example finds the least common gender of all the accounts.

PPL query:

os> source=accounts | rare gender; os> source=accounts | rare_approx 10 gender; os> source=accounts | rare_approx gender; fetched rows / total rows = 2/2 +----------+ | gender | |----------| | F | | M | +----------+
Example 2: Find the least common values organized by gender

The example finds the least common age of all the accounts group by gender.

PPL query:

os> source=accounts | rare 5 age by gender; os> source=accounts | rare_approx 5 age by gender; fetched rows / total rows = 4/4 +----------+-------+ | gender | age | |----------+-------| | F | 28 | | M | 32 | | M | 33 | | M | 36 | +----------+-------+