Expected Long(9) to be a org.neo4j.values.storable.TextValue, but it was a org.neo4j.values.storable

使用Load CSV指令导入到Neo4j中

出现了下面问题：

Expected Long(9) to be a org.neo4j.values.storable.TextValue, but it was a org.neo4j.values.storable.LongValue

原因是我导入的csv是有列名的，

load csv with headers from 'file:///diabetes.csv' as line with line return line limit 5

load csv with headers from 'file:///diabetes.csv' as line
 create (:Diabetes {
 DiabetesPedigreeFunction:line[1], 
 BloodPressure:line[2], 
 Outcome:line[3], 
 Glucose:line[4],
 SkinThickness:line[5],
 Insulin:line[6"],
 Pregnancies:line[7], 
 Age:line[8],
 BMI:line[9]})

当有表名的情况下，上面的写法就是不对的，需要制定表的名称，如下，

load csv with headers from 'file:///diabetes.csv' as line
create (:Diabetes {
DiabetesPedigreeFunction:line["DiabetesPedigreeFunction"], 
BloodPressure:line["BloodPressure"], 
Outcome:line["Outcome"], 
Glucose:line["Glucose"], 
SkinThickness:line["SkinThickness"],
Insulin:line["Insulin"],
Pregnancies:line["Pregnancies"], 
Age:line["Age"],
BMI:line["BMI"]})

Well Done