使用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