731 questions
0
votes
0
answers
24
views
Masking string quotes goes wrong in cypher
We have some objects in our DB, which roughly look like this:
MATCH (:State)--(sV:StateVal) WHERE sV.notOnDate IS NOT NULL RETURN sV LIMIT 2;
+----------------------------------------------------------...
- 3,283
1
vote
1
answer
47
views
APOC Cypher request with date format - Quotation marks error
I want to run this specific request in Cypher using the APOC plugin. It should transfer data from OracleXE to Neo4j. The problem is that in my OracleXE database, there is a property in timestamp ...
- 33
0
votes
1
answer
55
views
"name" is null: Neo4j’s APOC throws a NullPointerException when trying to map a type to a property
I am trying to import a JSON Lines file into Neo4j using its APOC plugin.
In this file, each object has a coordinates property, itself an object containing the latitude, longitude and height ...
- 1,046
0
votes
2
answers
132
views
Neo4j query to filter out paths with specific relationship property using apoc.path.expandConfig
I have a use case where I want to filter the paths retrieved from apoc.path.expandConfig based on a relationship property. Below is my current query:
WITH source, candidates, exits, typesFilter
// Use ...
- 392
0
votes
0
answers
47
views
How to check if a point is within a polygon (neo4j 5)
I'm using neo4j library in python
I want to check if a point is within a polygon (which will in our case will be state border)
I have check all the neo4j documentation but couldn't find any resource ...
- 283
2
votes
1
answer
59
views
The neo4j 3.5 version apoc.create.vRelationship does not return edge attributes
Here's my Cypher statement:
match (first1:ent) where first1.nodeid in ['aab40c4d65d5c0a428ed84dc0109b0c4']
match (first2:ent) where first2.nodeid in ['000415fee2b0272cdcc2439f521b2e2e']
CALL apoc....
- 33
0
votes
1
answer
59
views
Neo4j trigger not working as expected (freezes Next.js app)
I've installed a trigger in my Neo4j database (version 4.4.36) to automatically add the creation date to every newly created node. However, when I submit a form from my Next.js app, the app freezes, ...
1
vote
1
answer
44
views
Adding a place holder node when a null value is found in vrelationship function in neo4j
I have the following query that is working as expected in neo4j. The query matches and collects distinct FEATURE, THREAT, GAP, FACT, and SCENARIO nodes with their relationships based on a specific ...
- 1,375
0
votes
2
answers
99
views
Renaming Labels of relationships in Neo4j using parallel processing
I have a lot of relationships in my Neo4j Database for which I have to rename labels. As the number is quite high (close to 13 million), I am processing parallelly for faster execution. I believe my ...
0
votes
2
answers
148
views
Neo4j Browser expand only specific nodes
In Neo4j Browser, there is a visual option to expand a node in a graph so its other relationships that are not yet visible become visible (for example if you double click on the node).
My problem is, ...
- 1
0
votes
1
answer
57
views
Replacing all relationships between nodes in Neo4j
We've been investigating how to create or update multiple nodes and relationships in our Neo4j database at the same time. We have designed a format which clearly separates the unique Node ID, ...
- 2,787
0
votes
1
answer
66
views
Cypher query to find nodes where all relationships have a given property? ( deleted_at )
I choose to soft delete relationships on my graph, but I expect my nodes to have a single "active" relationship of a particular type. I ran into a scenario where some of my nodes ended up ...
- 15
2
votes
1
answer
219
views
Vector encoding provider AzureOpenAI is not supported under genai.vector.encode
Vector encoding provider AzureOpenAI is not supported in genai.vector.encode.
Error message below encountered:
ClientError: {code: Neo.ClientError.Procedure.ProcedureCallFailed} {message: Failed to ...
- 21
0
votes
1
answer
48
views
Neo4j variable declaration in apoc.do.when
I try to run a query in a fast api request, using apoc.do.when to take in consideration 2 value of the name field related to the node type Resource_Type:
@app.post("/filter/create", ...
- 17
0
votes
1
answer
64
views
How to return nodes and relationships only if a certain condition is true in cypher
In my database, I want certain nodes and relationships returned if items in 2 aggregated lists do not match. To be specific, a user has certain accesses and role. I want to pinpoint those users whose ...
- 17
0
votes
1
answer
237
views
Neo4j Aura (GCP) memory limit 18.7 GiB when instance has 64GB
On Neo4j Aura (GCP) I'm getting this error:
Neo.TransientError.General.MemoryPoolOutOfMemoryError
The allocation of an extra 2.0 MiB would use more than the limit 18.7
GiB. Currently using 18.7 GiB. ...
- 619
0
votes
1
answer
92
views
Neo4j out of memory exception when creating relationships via Neo4J Browser
MATCH (a:PARENT), (b:CHILD) WHERE a.id = b.id MERGE (b)-[:PART_OF]->(a)
I am running the above Neo4J query but I run into a memory exception, "the transaction size reached"
I updated the ...
- 1,654
2
votes
1
answer
157
views
Expand a path until a node with certain degree
Is there a way to expand a path until I find a node with degree n? I have a starting point and want to follow the path until I find a node that has a degree of more than 2 (so it forks the path). ...
- 159
1
vote
1
answer
188
views
Neo4j cypher query Double(NaN) issue
I have a query like I wrote below. I couldn't solve the error I gave below even after a lot of effort. I encounter this error when I do any sorting operation. But not always, in specific cases. I ...
0
votes
1
answer
50
views
Shortest path on a topological graph with default weight
Using neo4j (with APOC 5.7), I'm trying to find the shortest path on a topological graph (no location on the nodes), where the weight of each step is 1 by default. I don't want to limit the number of ...
- 16.1k
0
votes
1
answer
289
views
How to use apoc.path.subgraphAll procedure in Neo4j
I am doing a project in which I am required to return the path or nodes in a path from a particular start node. I pass the start node to the query, and need to continue down the path until the value ...
- 55
0
votes
0
answers
63
views
About crashing during a 2hop query operation in Neo4j
I have a question about how to deal with Neo4j queries that are slow and then crash.
First of all, let me explain the graphs.
There are 20million nodes called "Party". Each Party node has ...
- 49
0
votes
1
answer
123
views
Shortest path of weighted and directed graph in Neo4j
I created a map of city in Neo4j using OpenStreetMap and OpenAddresses data. I want to find the shortest path from one address to another. The problem is that, when I'm using function apoc.algo....
0
votes
1
answer
285
views
Neo4j: use in a projection a virtual relationship with weights
I can create a relationship in my graph, assign weights and write in disk as follows:
MATCH (a1:node1)-[rel1]-(p:other_node)-[rel2]-(a2:node2)
// create the weight
with a1.id as id1, a2.id as id2, ...
- 147
0
votes
1
answer
115
views
How to neo4j to Tigergraph (file is in graphml format)
i'm trying to migrate the schema from neo4j to tigergraph where i exported the data from neo4j in graphml format and trying to parse the file and create schema in tigergraph.
Do let me know if there ...
- 11