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
-
The approximate count of the rare (n) fields by using estimated cardinality by HyperLogLog++ algorithm
.
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 | +----------+-------+