java - Neo4j 中有 `Neo.ClientError.Statement.InvalidType`

Question

在 Neo4j 中运行以下查询时

USING PERIODIC COMMIT LOAD CSV WITH HEADERS FROM 'file:///home/peppa/database/ap/aC.csv' AS line
CREATE (:Aporte {Organization: line[1] ,ruc: line[2] , year: line[4] ,date: line[6] ,process: line[7] ,LastName: line[8] ,LastNameM: line [9] ,Name: line[10] ,DocType: line[11] ,DocNum: line[12] ,TypeAp: line[13] ,Nature: line[14]})

我收到以下错误:

Expected 10 to be a java.lang.String, but it was a java.lang.Long

不知道文件结构是否错误或我的查询错误。请帮忙!!.

编辑:我在以下查询中一直遇到相同的问题:

USING PERIODIC COMMIT 500 LOAD CSV WITH HEADERS FROM 'file:////home/peppa/database/aP/AC.csv' AS line
CREATE (:Ap  {dni: toint(line[1]) ,rc: toint(line[0])})

PD:我已经尝试过不使用 toint。

以下是我正在使用的一些数据:

"20501723844","06747807"
"20501723844","00803710"
"20501723844","40596835"
"20501723844","41696842"
"20501723844","27241420"
"20501723844","19249405"
"20501723844","23154926"
"20501723844","25446127"
"20501723844","18016385"
"20501723844","07093664"
"20501723844","07286049"
"20501723844","21140951"
"20501723844","10291445"
"20501723844","08866233"
"20501723844","09684232"
"20501723844","28297360"

Answer 1

查看此处提供的提示。

http://neo4j.com/developer/guide-import-csv/

可能您的数据集有一些不符合预期的内容