All OPAL verbs¶
Opal verbs process sets of rows of columns.
Verb |
Description |
---|---|
Add a candidate key to the output. |
|
Aggregates metrics across tag dimensions. |
|
Align raw metrics onto a time grid (defined by the input period) by aggregating nearby data points together. |
|
When the verb input is a Resource dataset, |
|
Selects all data for each of the bottom k ranked groups. |
|
dedup collapses all rows in a Table, Event, or Interval dataset with identical values in specified columns and with identical |
|
Exclude one or more columns from the input dataset to the output dataset. |
|
Removes one or more interface implementations from the current dataset. |
|
When the verb input is a Resource dataset, |
|
Return the rows from the default dataset that have a match anywhere in the query time window. |
|
Add one or more columns by matching capture names in a regular expression against a given source expression. |
|
Exclude rows from the input dataset that do not match the given predicate expression. |
|
Exclude rows from the input dataset that do not match the given predicate expression. |
|
Given an input of object or array type, recursively flatten all child elements into ‘_c_NAME_path’ and ‘_c_NAME_value’ columns |
|
Given an input of object or array type, recursively flatten all child elements into ‘_c_NAME_path’ and ‘_c_NAME_value’ columns |
|
Given an input of object or array type, recursively flatten all child elements into ‘_c_NAME_path’ and ‘_c_NAME_value’ columns |
|
Given an input of object or array type, flatten the first level of child elements into ‘_c_NAME_path’ and ‘_c_NAME_value’ columns. |
|
Return the rows from the additional joined dataset that have a match anywhere in the query time window. |
|
Temporal full join, adding new columns in the output dataset. |
|
Map fields of this dataset to a pre-defined interface. |
|
Temporal inner join, adding new columns in the output dataset. |
|
Temporal left join, adding new columns in the output dataset. |
|
Select the first |
|
Find matching rows in a Resource or Interval dataset, making new columns in the output dataset. |
|
Add one or more new columns from the input dataset to the output dataset. |
|
Creates an Event dataset from an input Table, Interval, or Resource dataset. |
|
Creates an Interval dataset from an input Table, Event, or Resource dataset. |
|
Creates a Resource dataset from an input Event or Interval dataset. |
|
Group events or intervals that are close to each other into sessions, and calculate aggregations over each session. |
|
Creates a Table dataset from an input Event, Interval, or Resource dataset. |
|
Merge consecutive events into new events based on merge conditions. |
|
When the verb input is a Resource dataset, |
|
Exclude all columns except the specified columns from the input dataset to the output dataset. |
|
The |
|
Include all columns while renaming the specified columns from the input dataset to the output dataset. |
|
Rollup raw metrics into aligned metrics |
|
Mark columns as enumerations, or not, by name. |
|
Mark resource columns as time immutable (time-invariant), or not. |
|
Include or exclude columns from any future full-text search operation (e. |
|
Show or hide columns by name. |
|
Declare the ‘label’ of the output to be the designated column. |
|
Add a foreign key to the output. |
|
Register a metric, with its metadata defined in an |
|
Specify the dataset that stores the metadata of the metrics defined in the current dataset. |
|
Declare the primary key of the output as consisting of one or more named columns. |
|
Declare the |
|
Declare the |
|
Sort rows in the dataset based on ordering functions applied to column fields or column name provided as arguments. |
|
Calculate statistics of columns with aggregate functions, based on (optional) grouping columns. |
|
Rows from the “right” dataset that fall within the specified frame of at least one row in the default dataset are unioned with the |
|
Bin (in time) and aggregate point or interval table columns through time, based on (optional) grouping columns. |
|
Aggregate resource columns at every point in time, based on (optional) grouping columns. |
|
Selects all data for each of the top k ranked groups. |
|
Create a new dataset consisting of the rows from the main input and each of the arguments. |
|
The |
|
Drop all outbound links without having to specify the individual labels. |
|
Remove the primary and candidate key declarations from the dataset. |
|
Drop a foreign key by specifying the foreign keys label. |
|
Remove all column sort ordering metadata that may have been inserted by the sort verb for the rest of the current OPAL pipeline. |
|
Augments the input Resource dataset using events from another dataset. |
Aliases
Aliases work as alternative names for their main verb. Users of certain other query languages may be more comfortable with these alternative names. Alias names on this list can always be used whenever the main name can be used.