Hi there,
I'm experimenting with Neo4j while benchmarking a bunch of NoSQL databases
for my graduation paper.
I'm using the web interface to populate the database. I've been able to
load the smaller tables from my SQL database and LOAD CSV works fine.
By small, I mean a few columns (4-5) and some rows (1 million). However,
when I try to upload a larger table (15 columns, 12 million rows), it
creates the nodes but it doesn't set any properties.
I've tried to reduce the number of records (to 100) and also the number of
columns( just the Id property ), but no luck so far.
The cypher command used is this one
USING PERIODIC COMMIT 100
LOAD CSV WITH HEADERS FROM "file:/Users/pauld/Documents/Client.csv" AS c
CREATE (:Client { Id: toInt(c.Id), FirstName: c.FirstName, LastName:
c.Lastname, Address: c.Address, ZipCode: toInt(c.ZipCode), Email: c.Email,
Phone: c.Phone, Fax: c.Fax, BusinessName: c.BusinessName, URL: c.URL,
Latitude: toFloat(c.Latitude), Longitude: toFloat(c.Longitude), AgencyId:
toInt(c.AgencyId), RowStatus: toInt(c.RowStatus)})
Any help and indication is welcomed,
Paul
--
You received this message because you are subscribed to the Google Groups
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
