Search code examples
complex-event-processingesper

Infinite loop when inserting and selecting from same Esper window

Is there a way to insert into the same window that is part of the from clause within Esper?

For example ...

insert into HaltEvent
select haltType(t, w) type
from StockEvent#lastevent as t
left outer join HaltEvent#keepall w

Above haltType is a user defined function that is dependent HaltEvent. Since there is a left outer join, this will at least return at least the one StockEvent with HaltEvent as null. In the event there is a HaltEvent for a stock, the haltType will take into account the previous HaltEvent attributes.

In the above query, since HaltEvent is included as part of keepall, and endless set of HaltEvents is created.

Can I tell Esper to do something like, "Ignore the events added as part of this query"?

Solution

  • No there isn't such a "ignore events", but why insert into HaltEvent in the first place?