Describe the bug
While importing relationships (edges) from a CSV file, ArcadeDB throws the error:
"Target node does not exist in DB", even though the nodes were previously loaded successfully.
Steps to reproduce
-
Load nodes using nodes.csv:
LOAD CSV WITH HEADERS FROM 'file:///nodes.csv' AS row
CREATE (:Node {NodeID: row.NodeID})
-
Verify nodes:
MATCH (n:Node) RETURN n LIMIT 10
-
Load edges using edges.csv:
LOAD CSV WITH HEADERS FROM 'file:///edges.csv' AS row
MATCH (a:Node {NodeID: row.Source})
MATCH (b:Node {NodeID: row.Target})
CREATE (a)-[:RELATION]->(b)
Expected behavior
Edges should be created successfully between existing nodes.
Actual behavior
Edge creation fails with error:
"Target node does not exist in DB"
Environment
- ArcadeDB Version: 1.7.0
- OS: Windows (WSL/Ubuntu)
- Deployment: Docker
Additional context
- Nodes are loaded from CSV before edges
- NodeID values in nodes.csv and edges.csv are expected to match
- Sample failing records:
ba-llb-h → nluj
bba-llb-h → nluj
Describe the bug
While importing relationships (edges) from a CSV file, ArcadeDB throws the error:
"Target node does not exist in DB", even though the nodes were previously loaded successfully.
Steps to reproduce
Load nodes using nodes.csv:
LOAD CSV WITH HEADERS FROM 'file:///nodes.csv' AS row
CREATE (:Node {NodeID: row.NodeID})
Verify nodes:
MATCH (n:Node) RETURN n LIMIT 10
Load edges using edges.csv:
LOAD CSV WITH HEADERS FROM 'file:///edges.csv' AS row
MATCH (a:Node {NodeID: row.Source})
MATCH (b:Node {NodeID: row.Target})
CREATE (a)-[:RELATION]->(b)
Expected behavior
Edges should be created successfully between existing nodes.
Actual behavior
Edge creation fails with error:
"Target node does not exist in DB"
Environment
Additional context
ba-llb-h → nluj
bba-llb-h → nluj