Error after running query

Neo4j Graph Platform Import / Export
1

I'm attempting to generate a graph from an imported dataset. The dataset consists of three columns: Current, Voltage, and Temperature. Each row in these columns contains an array of values instead of a single value , and thn i faced this problem : "The allocation of an extra 2,0 MiB would use more than the limit 716,8 MiB. Currently using 716,0 MiB. dbms.memory.transaction.total.max threshold reached" and this is the query : LOAD CSV WITH HEADERS FROM 'file:///MIT_dataset.csv' AS row
CREATE (:TF {
Time_To_Charge: row.Timec
})
Version 5.19 Neo

2

How many rows of data are you importing. As your query is written, all the nodes will be created in one transaction, which requires memory.

You can perform the create operations in multiple transactions. This should require less memory

:auto
LOAD CSV WITH HEADERS FROM 'file:///MIT_dataset.csv' AS row
Call {
  With row
  CREATE (:TF {Time_To_Charge: row.Times}) 
} in transactions of 10,000 rows
1 Like