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

frame

frame

Optional

Only one

predicate

bool

Required

Can be multiple

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

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.