bitnine-oss / agensgraph

AgensGraph, a transactional graph database based on PostgreSQL
http://www.agensgraph.org
Other
1.33k stars 148 forks source link

Is there a way to do complex path expansion in agensgraph? #501

Open jafri opened 4 years ago

jafri commented 4 years ago

In neo4j, you have APOC queries that enable variable length path traversals.

"The apoc.path.expand procedure makes it possible to do variable length path traversals where you can specify the direction of the relationship per relationship type and a list of Label names which act as a "whitelist" or a "blacklist" or define end nodes for the expansion. The procedure will return a list of Paths in a variable name called "path".

Source: http://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/path-finding/path-expander/

Is it possible to do a similar type of complex path expansion with agensgraph?

joefagan commented 4 years ago

Yes it is possible to similar traversals/queries but not exactly the same.

On Thu, 12 Dec 2019 at 22:23, Syed Jafri notifications@github.com wrote:

In neo4j, you have APOC queries that enable variable length path traversals.

"The apoc.path.expand procedure makes it possible to do variable length path traversals where you can specify the direction of the relationship per relationship type and a list of Label names which act as a "whitelist" or a "blacklist" or define end nodes for the expansion. The procedure will return a list of Paths in a variable name called "path".

Source: http://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/path-finding/path-expander/

Is it possible to do a similar type of complex path expansion with agensgraph?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/bitnine-oss/agensgraph/issues/501?email_source=notifications&email_token=ALQMI2AYJ4457BTZGCJGHKLQYK2WTA5CNFSM4J2FGHB2YY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4IAFXB3Q, or unsubscribe https://github.com/notifications/unsubscribe-auth/ALQMI2DAD37Q655BB5CHZHLQYK2WTANCNFSM4J2FGHBQ .

jafri commented 4 years ago

@joefagan are there any examples I could look at on how to achieve this without APOC?

Its a major point that we are considering when evaluating whether to move from neo4j to agensgraph, would be great to see how similar functionality could be achieved.