Questions tagged [neo4j-apoc]

APOC is short for "Awesome Procedures on Cypher." Introduced in Neo4j release 3.0, APOCs are callable procedures which extend the Cypher query language.Questions with the neo4j-apoc tag should be for "small, generic helper functions for common tasks" that are not available in the Cypher query language.

APOC procedures are "User Defined Procedures." They are similar to stored procedures in some relational databases. APOCs can be written in any language that runs on the JVM. Questions tagged with neo4j-apoc should have an accompanying tag for the specific language being used.

Built in procedures are included in Neo4j releases. Before posting a question on StackOverflow, please consult the Neo4j documentation and ask if your task is possible in the public chat channels.

685 questions
2
votes
0 answers

Neo4j fails to start up due to trigger execution failure

I have a triggered called create-owner-notification. It worked like a charm after creating it, but after a restart of Neo4j it blocks a successful start up of the database. The error found in debug.log is: [a.t.Trigger] Error executing trigger…
N Meibergen
  • 362
  • 2
  • 14
2
votes
1 answer

Cypher - How to call a procedure multiple times in loop?

In Neo4j Browser, I tried to call a procedure multiple times in a loop, but Neo4j reported the same error: Query cannot conclude with CALL (must be RETURN or an update clause). Specifically, With UNWIND (documentation): UNWIND [10, 20] AS…
JoyfulPanda
  • 867
  • 6
  • 14
2
votes
0 answers

Neo4j 4.0 Define APOC custom procedure

I'm using Neo4j 4.0.3 Community (with Docker), apoc-4.0.0.7-all.jar and have a problem when calling APOC custom procedure. Here is the code, which works with Neo4j 3.5.17. Am I missing something in the new version? // Create Nodes and…
mbh86
  • 6,078
  • 3
  • 18
  • 31
2
votes
1 answer

Cypher query for list pattern

I have a schema which looks like below: A customer is linked to another customer with a relationship SIMILAR having similarity score. Example: (c1:Customer)-->(c2:Customer) An Email node is connected to each customer with relationship MAIL_AT with…
Asif Ali
  • 1,422
  • 2
  • 12
  • 28
2
votes
1 answer

Neo4J Enterprise slower than Community?

I've been doing some testing between Neo4J Community 3.3.3, Enterprise 3.3.9 and Enterprise 3.5.17. To my surprise, the newer the version, the longer it took for requests to process. And yes, I checked that all the indexes (both internal and APOC…
Aerodynamika
  • 7,883
  • 16
  • 78
  • 137
2
votes
1 answer

What does parameters limit and maxLevel mean in Neo4j apoc query?

By reading the official Neo4j documentation, I can't understand what does the two parameters limit and maxLevel mean in a apoc.path.subgraphnodes. https://neo4j-contrib.github.io/neo4j-apoc-procedures/3.5/path-finding/path-expander/ Anyone can help…
thomask
  • 743
  • 7
  • 10
2
votes
0 answers

neo4j apoc.load.json: load all files from a directory

In Neo4j, How can I call apoc.load.json on all files that are in a directory? Is there any cypher command to interact with the system directory? Or si there apoc function/procedure?
Bruno C
  • 199
  • 13
2
votes
0 answers

Neo4j APOC export/import with primary keys instead of internal ids

I am trying to import multiple CSVs, exported from multiple different Neo4j databases with APOC's export, into one big database. Some of the nodes are shared. There is a problem that relationships in the CSV use the Neo4j's internal IDs for the…
shelll
  • 3,234
  • 3
  • 33
  • 67
2
votes
1 answer

Counting distinct nodes in path

I have a graph with customers, transactions, and merchants with connections that look as follows: (Customer)->(Transaction)->(Merchant). I'm trying to effectively return a new graph that connects the various merchants by the number of shared…
2
votes
1 answer

Why does my apoc.refactor.cloneNodes call iterate and create clones for every node in graph?

I intended to clone a single node and its 3 connections, but ended up with multiple clones. By first MATCHing the entire graph of primary node and related nodes, when I call apoc.refactor.cloneNodes, it seems to iterate over each related node…
ChillyNeo
  • 25
  • 5
2
votes
1 answer

Neo4j add property to relationship when using apoc.merge.relationship()

I have the following import: // NO ATTACHMENT OR LINK USING PERIODIC COMMIT 1000 LOAD CSV WITH HEADERS FROM ("file:///sessions/Hourly_Parsed/2019-12-10_00_hourly_parsed_mail_logs.csv") AS row MERGE (a:Sender { name: row.From, domain:…
sectechguy
  • 2,037
  • 4
  • 28
  • 61
2
votes
1 answer

Nested apoc iterate with apoc load jdbc returns "cannot conclude with CALL" message

I am calling a nested apoc procedure to iterate the loading of data via jdbc driver from mysql to ingest into neo4j. The statement looks as follows: WITH 'jdbc:mysql://x.x.x.x:3306/schema?user=x&password=x' AS url, 'select * from table' AS query…
saigafreak
  • 405
  • 6
  • 14
2
votes
1 answer

Neo4j returning duplicate nodes while traversing

While querying the ne04j for the traversing order. it's traversing multiple times few nodes. I am attaching the cypher query to create nodes and relationships and results it returns. Any help is appreciated. CREATE (a:Package {name:'A'}) CREATE…
user1844634
  • 1,221
  • 2
  • 17
  • 35
2
votes
0 answers

Can I use apoc.periodic.updates to return a query output?

I have a query that reads a set of ID's from a csv file, searches for those nodes in the database and writes the results to a csv. I'm trying to get this query to run as quickly as possible and was wondering if I could parallelise the read operation…
Matt
  • 437
  • 2
  • 14
2
votes
3 answers

Degree centrality algorithm returns only 0.0 as score

I'm trying to run the degree centrality algorithm on my dataset. The submodel of my query looks like this: (transfer:Transfer)-[:PARENT_TRANSFER]->(hasUnderlyingBatch:HasUnderlyingBatch) The query that I'm trying to run: CALL…
Johan
  • 23
  • 3