Neo4j创建/插入带有csv错误的数据

Question

USING PERIODIC COMMIT
LOAD CSV WITH HEADERS FROM "file:///friends1k\\person.csv" AS row
CREATE (:person {personID: row.personID, name: row.name, email: row.email, telefon: row.telefon});

CREATE INDEX ON :person(personID);

schema await

USING PERIODIC COMMIT
LOAD CSV WITH HEADERS FROM "file:///friends1k\\friendship.csv" AS row
MATCH (p1:Person {personID: row.pfrom})
MATCH (p2:Person {personID: row.pto})
MERGE (p1)-[:FRIENDSHIP]->(p2);

这个想法来自这个网站(https://neo4j.com/developer/guide-import-data-and-etl/）。

该import.cypher的输出是:``+-----------+没有返回数据。+--------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------+312毫秒

现在我用以下查询测试它:

MATCH (me:person)-[:FRIENDSHIP]-(friends:person)
WHERE me.personID='1'
RETURN count(friends);

输出如下：+----------------------------------------------------------------------------------------------------------------------------------------------

但结果应该是2个，因为每个人都有两个朋友。




Answer 1

当您创建一个关系时，您如何看待没有进行任何更改：

 No data returned, and nothing was changed. 

这是因为密码中节点的标签和关系类型是区分大小写的，并且match找不到相关的节点：

:person != :Person

因此，您需要修复查询并重复创建关系：

USING PERIODIC COMMIT
LOAD CSV WITH HEADERS FROM "file:///friends1k\\friendship.csv" AS row
MATCH (p1:person {personID: row.pfrom})
MATCH (p2:person {personID: row.pto})
MERGE (p1)-[:FRIENDSHIP]->(p2);