I am dealing with two event types: request_start and request_end . Both have a request_id field. Is there a way that I can find all request_start events that exist where there is no request_end event with the same request_id ?
I've found on here that it's easy to filter out events having the same value in two different fields, but this is different because it requires a "WHERE NOT EXISTS" sort of predicate to reference another event rather than comparing values in the same event.
... View more