cancel
Showing results for 
Search instead for 
Did you mean: 

Join the community at Nodes 2022, our free virtual event on November 16 - 17.

How to import a Map object to neo4j from a csv using neo4j-admin utility

bishnu12
Node

Hello All,

I have been using neo4j-admin utility for sometime now to import around 400 million records with each containing on an average 30 properties. The records are in the format of multiple csv.

However I am facing a problem where I am trying upload a field with a map, but it seems there is no support for this. For example,

movieId:ID,title,year:int,valueMap,:LABEL
tt0133093,"The Matrix",1999,{one=1,two=2,three=3},Movie
tt0234215,"The Matrix Reloaded",2003,{four=4,five=5,six=6},Movie;Sequel
tt0242653,"The Matrix Revolutions",2003,{seven=7,eight=8,nine=9},Movie;Sequel

The documentation also mentions only this.

Use one of int , long , float , double , boolean , byte , short , char , string , point , date , localtime , time , localdatetime , datetime , and duration to designate the data type for properties. If no data type is given, this defaults to string . To define an array type, append [] to the type

I am using the neo4j OGM to fetch the data and it doesn't recognize the map object which I have defined when I try to fetch it.
@property
Map valueMap<String,String>

"valueMap": "{one=1,two=2,three=3}"

If I store it using the OGM, I get below as an output and it is able to understand it.

"valueMap.one": "1",
"valueMap.two": "2",
"valueMap.three": "3",

Is there a way I can define the properties in the csv and then load it using the import utility, which can return me the above format ?

Thanks,
Bishnu

0 REPLIES 0
Nodes 2022
Nodes
NODES 2022, Neo4j Online Education Summit - November 16 - 17, 2022.


Free NODES Training Series


October 19th -

Intro to Neo4j


October 20th -

Healthcare Analytics Using Neo4j


October 25th -

Handling Neo4j data with Apache Hop


October 26th -

Blazing Fast Graphs: Hands-on with Apache Arrow and Neo4j


November 2nd -

Graph EDA Using the Neo4j GDS Client