neo4j - 必须为 Neo4j 中的 CREATE 指定单一关系类型

Question

我正在尝试使用以下查询在两个节点之间创建关系:

load csv with headers from 
"file:C:/Users/abc/Documents/Neo4j/RT__RISK_LOSSEVENT.csv" as risklossevent 
match (a: RT__RISK_LOSSEVENT {LossEventId: risklossevent.LOSSEVENT_ID}),
(b: RT_RISK {RiskId: risklossevent.RISK_ID}) 
create (a)-[ASSOCIATED_WITH]->(b);

它抛出一个错误说明

A single relationship type must be specified for CREATE (line 1, column 236 (offset: 235))

Neo.ClientError.Statement.InvalidSyntax

为了创建两个节点，我使用了以下查询:

load csv with headers from 
file:C:/Users/abc/Documents/Neo4j/RT__RISK_LOSSEVENT.csv" as risklossevent
create (rle1:RT__RISK_LOSSEVENT {RiskId: risklossevent.RISK_ID, LossEventId: risklossevent.LOSSEVENT_ID});

load csv with headers from "file:C:/Users/abc/Documents/Neo4j/RT_RISK.csv" as risk 
create (rle3:RT_RISK {RiskId: risk.RISK_ID, Owner: risk.OWNER, RiskCategory: risk.RISK_CATEGORY, Description: risk.DESCRIPTION});

任何人都知道语法或查询有什么问题？

Answer 1

实际上，您得到的异常与您的语法错误无关，因此没有意义。

您忘记添加 colon ::在查询中的关系类型之前:

create (a)-[:ASSOCIATED_WITH]->(b);