我正在使用下面链接中的grades.csv数据,
https://people.sc.fsu.edu/~jburkardt/data/csv/csv.html
我注意到csv文件中的所有字符串都在“”中,这会导致
错误消息:
Neo.ClientError.Statement.SemanticError: Cannot merge node using null property value for Test1
所以我删除了标题中的“”
我试图运行的代码:
LOAD CSV WITH HEADERS FROM 'file:///grades.csv' AS row
MERGE (t:Test1 {Test1: row.Test1})
RETURN count(t);
错误消息:
Neo.ClientError.Statement.SyntaxError: Type mismatch: expected Any,Map,Node,Relationship,Point,Duration,Date,Time,LocalTime,LocalDateTime or DateTime but was List<String> (line 2,column 24 (offset: 65))
"MERGE (t:Test1 {Test1: row.Test1})