Can i import my primary key in Neo4j with CSV

Question

I'm importing CSV files to Neo4J, but Neo4J doesn't import my primary key.

I'm using this:

LOAD CSV WITH HEADERS FROM "file:///C:/c/tabela_sujeito.csv" AS row
CREATE(:Sujeito{suj_ID:row.id, idade:row.idade, altura:row.altura, peso:row.peso, genero:row.genero, mao_dominante:row.mao_dominante});

suj_ID is my primary key, and it isn't imported, unlike the other attributes.

Can you share the first few of the records along with header? It's difficult to say something without seeing your file. — Rajendra Kadam, May 30 '19 at 15:20
**There is no concept of `primary key` in Neo4j**. You can add a unique constraint on a property if required. — Rajendra Kadam, May 30 '19 at 15:22
I know that in neo4j there isn't primary key. The records are like: "3,27,173,69,masculino,direita 4,25,175,90,masculino,direita" — dlmartins, May 30 '19 at 15:30
"3" and "4" are the PK. And i need to import that, but only imports the other attributes — dlmartins, May 30 '19 at 15:31
Yes. "suj_ID,idade,altura,peso,genero,mao_dominante" suj_ID it's the PK — dlmartins, May 30 '19 at 15:33
In that case you need to use `row.suj_ID`, and not `row.id` as you currently have in your CREATE. — InverseFalcon, May 30 '19 at 15:34

score 1 · Answer 1 · answered May 30 '19 at 15:38

1

As suggested by @InverseFalcon, You need to use row.suj_ID instead of row.id in your query.

LOAD CSV WITH HEADERS FROM "file:///C:/c/tabela_sujeito.csv" AS row
CREATE(:Sujeito{suj_ID:row.suj_ID, idade:row.idade, altura:row.altura, peso:row.peso, genero:row.genero, mao_dominante:row.mao_dominante});

answered May 30 '19 at 15:38

Rajendra Kadam

4,004
1
10
24

Other question, did you know how can i increase dbms.memory.heap.max_size in neo4j desktop? – dlmartins May 30 '19 at 15:40
Separate questions belong in separate questions :-) – cybersam May 30 '19 at 19:43

Can i import my primary key in Neo4j with CSV

1 Answers1