exists

Type of operation: Join

Description

Return the rows from the default dataset that have a match anywhere in the query time window. (Nontemporal semijoin)

Usage

exists [ frame ], predicate ...

Argument	Type	Required	Multiple	Constant
frame	frame	Optional	Only one	Variable
predicate	bool	Required	Can be multiple	Variable

Accelerable

exists is accelerable if there is a frame() argument. A dataset that only uses accelerable verbs can be accelerated, making queries on the dataset respond faster.

Examples

exists [email protected]_id

Semijoin the default dataset with the ‘right’ dataset, returning rows from ‘default’ where there exists a key match at any point in time within the query window.

exists frame(back:30m), [email protected]_id

Semijoin the default dataset with the ‘right’ dataset, returning rows from ‘default’ where there exists a key match within 30 minutes in time.

exists [email protected]_id and sensor_value>@right.sensor_value

Semijoin the default dataset with the ‘right’ dataset, returning rows from ‘default’ where sensor_value is greater than the value from ‘right’ for the same sensor_id at any point in time within the query window.