cancel
Showing results for 
Search instead for 
Did you mean: 

What is the "Eager Operator" and where can I find more info on it

glilienfield
Ninja
Ninja

I have noticed if I write queries with complex usage of the 'with' clause, I get the warning shown below discussing the 'eager' operator. Can someone tell me what this is, where can I find more info on it in the manuals, and what I can do in the sample query to eliminate the warning?

Thanks....

LOAD CSV WITH HEADERS
FROM 'file:///xxx.csv' as rowStore
with rowStore.Entity as Entity, rowStore.EventType as EventType, date(rowStore.Timestamp) as EventDate
merge(n:Entity{id: Entity})
merge(m:EventType{id: EventType})
merge(n)-[r:EventDate]->(m)
on create set r.EventDate = EventDate
on match set r.EventDate = apoc.coll.min([r.EventDate, EventDate])
with n, EventDate
match(n)-[r:EventDate]->(p:EventType)
where r.EventDate <> apoc.coll.min([r.EventDate, EventDate])
delete r

3 REPLIES 3

youcef_kadri
Node Link

I found this very useful: Cypher Sleuthing: the eager operator

glilienfield
Ninja
Ninja

This looks really informative. Thanks very much.

venkat1
Node Link

@glilienfield: Thanks for asking the question.
@youcef.kadri: Thanks a bunch for the useful article.