Query all complete net of a specific node

Neo4j Graph Platform Cypher
,
1

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

2

Hi @arturo.guerrero ,

Take a look on:

3

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

4

Hi @arturo.guerrero !

You can always try:

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

Bennu

5

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

6

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

7

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

Thank you

8

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

9

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