not_exists#

Type of operation: Join

Description#

Return the rows from the default dataset that do not have a match anywhere in the query time window.

not_exists performs a nontemporal antisemijoin. The join will select any rows from the first dataset that do not have at least one matching row in the second dataset.

Usage#

not_exists [ frame ], predicate_1, predicate_2, ...

Argument

Type

Optional

Repeatable

Restrictions

frame

frame

yes

no

constant

predicate

bool

no

yes

none

Accelerable#

not_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#

not_exists [email protected]_id

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

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

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