Head's Up! Site maintenance this Wednesday, February 1. Disruptions expected as we migrate the forums.
β03-16-2022 01:39 AM
neo4j Tried to read a field larger than buffer size 2097152. A common cause of this is that a field has an unterminated quote and so will try to seek until the next quote, which ever line it may be on. This should not happen if multi-line fields are disabled, given that the fields contains no new-line characters
β03-16-2022 01:40 AM
β03-16-2022 03:02 AM
I am trying to import the data from csv file and im facing the above error.
I increased the dbms.import.csv.buffer_size to 209715200. But error still keeps on coming
β04-01-2022 08:31 AM
Hi,
I got the same error like the following when i tried to import csv as node through py2neo.
py2neo.errors.DatabaseError: [Statement.ExecutionFailed] Tried to read a field larger than buffer size 2097152. A common cause of this is that a field has an unterminated quote and so will try to seek until the next quote, which ever line it may be on. This should not happen if multi-line fields are disabled, given that the fields contains no new-line characters.
The cypher that i used is Β¨
USING PERIODIC COMMIT
LOAD CSV WITH HEADERS FROM 'file:///file.csv' AS row
CREATE (: labelName{ id: toInteger(row.id), ....});
Regards,
yhchen
β04-01-2022 09:28 AM
The csv file was too huge and i was getting the above error. I splitted the csv file into 3 and import was successful without any issues... Hope that will work for that for u is well
All the sessions of the conference are now available online