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"?
No there isn't such a "ignore events", but why insert into HaltEvent in the first place?