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 never accelerable. 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.