Query all complete net of a specific node

[arturo_guerrero]

Dear Neo4j friends,
maybe someone can help me with a query.
I want to retrieve a complete net of a specific node. (All the nodes related somehow with a specific node).

Thank you in advance

[Bennu]

Hi @arturo.guerrero ,

Take a look on:

Neo4j Graph Database Platform

Expand to nodes in a subgraph - APOC Documentation

This section describes a procedure that expands a subgraph from a set of start nodes, and returns all nodes within the subgraph.

[arturo_guerrero]

Hello Bennu,
thank you for your reply, but I´m not able to run APOC on the community edition I´m working with.

[Bennu]

Hi @arturo.guerrero !

You can always try:

MATCH(a)
WHERE //Set conditions here
WITH a
MATCH (a)-[*]->(b)
RETURN collect(b) as related

Bennu

[arturo_guerrero]

Thank you Bennu,
I tried with your query, but I missed some information in return.
Then I tried to modify your query and instead I try this one:

MATCH(a)
WHERE //Set conditions here
WITH a
MATCH (a)-[*]-(b)
RETURN collect(b) as related

for returning bidirectional relationships, but trying this my server went down. Do you know why?
I´m only trying to find a way to have all the connection in a connected cluster and avoiding unconnected nodes.

Thank you

[Bennu]

Hi @arturo.guerrero!

Did you set any condition on a? Otherwise you are going to query pretty much the entire db and you may have OOM problems (out of memory).

Bennu

[arturo_guerrero]

yes I set a condition on a . I set WHERE id(a) = (a node id-number).

Thank you

[Bennu]

Hi @arturo.guerrero!

Can you confirm with the log that it was a OOM problem?

How much ram do you have? How big is the DB/xpected result of the query?

Can you use APOC library on your db?

Bennu

[arturo_guerrero]

Dear Bennu,
the RAM is about 8 GB, but my graph has in total only 161 nodes. No so much I think.
I can´t use APOC, because I haven´t access to the server directly.

Thank you