时间戳

首页 > 解决方案 > Neo4j 版本。4.1.1 密码语法错误“使用定期提交”

neo4j - Neo4j 版本。4.1.1 密码语法错误“使用定期提交”

问题描述

来自 NASA 的 neo4d 经验教训示例

引用一个 github 项目，展示 NASA 如何使用 Neo4J 创建经验教训数据库。从 2015 年开始，我一直在努力让 Cypher 代码在新版本的 Neo4j 上运行（我正在学习）。

我收到的错误消息是 在此处输入图像描述 我的修改版本如下。

MATCH (n)
OPTIONAL MATCH (n)-[r]-()
DELETE n,r;

USING PERIODIC COMMIT 500
LOAD CSV WITH HEADERS FROM 'file:///Users/kevin/Neo4j/doctopics-master/data/llis.csv' 
AS line
WITH line
Limit 1
RETURN line

USING PERIODIC COMMIT
LOAD CSV WITH HEADERS
FROM 'file:///Users/kevin/Neo4j/doctopics-master/data/llis.csv' AS line
WITH line, SPLIT(line.LessonDate, '-') AS date
CREATE (lesson:Lesson { name: ToInteger(line.`LessonId`) } )
SET lesson.year = ToInteger(date[0]),
   lesson.month = ToInteger(date[1]),
   lesson.day = ToInteger(date[2]),
   lesson.title = (line.Title),
   lesson.abstract = (line.Abstract),
   lesson.lesson = (line.Lesson),
   lesson.org = (line.MissionDirectorate),
   lesson.safety = (line.SafetyIssue),
   lesson.url = (line.url)
MERGE (submitter:Submitter { name: toUpper(line.Submitter1) })
MERGE (center:Center { name: toUpper(line.Organization) })
MERGE (topic:Topic { name: ToInteger(line.Topic) })
MERGE (category:Category { name: toUpper(line.Category) })
CREATE (topic)-[:Contains]->(lesson)
CREATE (submitter)-[:Wrote]->(lesson)
CREATE (lesson)-[:OccurredAt]->(center)
CREATE (lesson)-[:InCategory]->(category);
USING PERIODIC COMMIT
LOAD CSV WITH HEADERS
FROM 'file:///Users/kevin/Neo4j/doctopics-master/data/topicCategory.csv' AS line
MATCH (topic:Topic { name: ToInteger(line.Topic) })
MATCH (category:Category { name: toUpper(line.Category) })
CREATE (topic)-[:AssociatedTo]->(category)
;


// Topic, Correlation.
// Adds a relation to each topic using their correlation
// as a property of the relationship

// Load.
USING PERIODIC COMMIT
LOAD CSV WITH HEADERS
FROM 'file:///Users/kevin/Neo4j/doctopics-master/data/topicCorr.csv' AS line

MATCH (topic:Topic), (topic2:Topic)
WHERE topic.name = ToInteger(line.Topic) AND topic2.name = ToInteger(line.ToTopic)

MERGE (topic)-[c:CorrelatedTo {corr : ToFloat(line.Correlation)}]-(topic2)
;


USING PERIODIC COMMIT
LOAD CSV WITH HEADERS
FROM 'file:///Users/kevin/Neo4j/doctopics-master/data/topicTerms.csv' AS line
MATCH (topic:Topic { name: ToInteger(line.Topic) })
MERGE (term:Term { name: toUpper(line.Terms) })
CREATE (term)-[r:RankIn {rank : ToInteger(line.Rank)}]->(topic)
;

USING PERIODIC COMMIT
LOAD CSV WITH HEADERS
FROM 'file:///Users/kevin/Neo4j/doctopics-master/data/topicLabels.csv' AS line
MATCH (topic:Topic { name: ToInteger(line.Topic) })
SET topic.label = line.Label

;

原始的 Cypher 代码和数据在David Meza 的 Repo中

我只想准备好明天早上向我们公司演示的东西，以“出售”“经验教训”和图形数据库的使用。任何帮助将不胜感激。

谢谢

标签： neo4jcyphercql

解决方案

你试过了吗

DELETE n,r

在第 3 行？

顺便说一句，清除商店也可以这样完成，这可能更快。

MATCH (n)
DETACH DELETE n

推荐阅读