any difference between the cypher query

[VinACE]

Approach one, agens-# MATCH (a : v_p), (b : v) agens-# with distinct b.buy_f_vendor as bp, a.buy_f_vendor as ap agens-# WHERE bp = ap agens-# CREATE (a)-[:bought_from_vendor] ->(b); GRAPH WRITE (INSERT VERTEX 884, INSERT EDGE 442)

After this unable to query the relationship

Approach two, taking a long time create the relationship more than 9+ hours.. for MATCH (a: v_p), (b:v) where b.buy_f_vendor = a.buy_f_vendor
CREATE (a) - [r : bought_f_vendor] -> (b)

shared memory 6GB and worker memory 2GB

[htlim]

Hi. @VinACE

You might want to refer to this site.

[VinACE]

, I went through the link you have shared, The examples given are for two tables, Is there a way achieve the same with Union examples given in the developer guide.

[ontologiae]

You probably have a great cartesian product which produces so much data that you create billions of edge.