What does your query look like? Please switch to Neo4j 2.1.2 And create indexes / constraints for the nodes you're inserting with merge or looking up via MATCH.
Am 18.06.2014 um 08:46 schrieb Pavan Kumar <[email protected]>: Hi, I have deployed neo4j 2.1.0-M01 on windows which has 8GB RAM. I am trying to import CSV file which has 30000 records. I am using USING PERIODIC COMMIT 1000 LOAD CSV command for importing, but it gives unknown error. I have modified neo4j.properties file as adviced in the blogs. My neo4j.properties now looks like # Default values for the low-level graph engine neostore.nodestore.db.mapped_memory=200M neostore.relationshipstore.db.mapped_memory=4G neostore.propertystore.db.mapped_memory=500M neostore.propertystore.db.strings.mapped_memory=500M neostore.propertystore.db.arrays.mapped_memory=500M # Enable this to be able to upgrade a store from an older version allow_store_upgrade=true # Enable this to specify a parser other than the default one. #cypher_parser_version=2.0 # Keep logical logs, helps debugging but uses more disk space, enabled for # legacy reasons To limit space needed to store historical logs use values such # as: "7 days" or "100M size" instead of "true" keep_logical_logs=true # Autoindexing # Enable auto-indexing for nodes, default is false node_auto_indexing=true # The node property keys to be auto-indexed, if enabled #node_keys_indexable=name,age # Enable auto-indexing for relationships, default is false relationship_auto_indexing=true # The relationship property keys to be auto-indexed, if enabled #relationship_keys_indexable=name,age # Setting for Community Edition: cache_type=weak Still i am facing the same problem. Is there any other file to change properties. Kindly help me in this issue. Thanks in advance On Tuesday, 4 March 2014 21:24:03 UTC+5:30, Aram Chung wrote: > > Hi, > > I was asked to post this here by Mark Needham (@markhneedham) who thought > my query took longer than it should. > > I'm trying to see how graph databases could be used in investigative > journalism: I was loading in New York State's Active Corporations: > Beginning 1800 data from https://data.ny.gov/Economic-Development/Active- > Corporations-Beginning-1800/n9v6-gdp6 as a 1964486-row csv (and deleted > all U+F8FF characters, because I was getting "[null] is not a supported > property value"). The Cypher query I used was > > USING PERIODIC COMMIT 500 > LOAD CSV > FROM "file://path/to/csv/Active_Corporations___Beginning_1800_ > _without_header__wonky_characters_fixed.csv" > AS company > CREATE (:DataActiveCorporations > { > DOS_ID:company[0], > Current_Entity_Name:company[1], > Initial_DOS_Filing_Date:company[2], > County:company[3], > Jurisdiction:company[4], > Entity_Type:company[5], > > DOS_Process_Name:company[6], > DOS_Process_Address_1:company[7], > DOS_Process_Address_2:company[8], > DOS_Process_City:company[9], > DOS_Process_State:company[10], > DOS_Process_Zip:company[11], > > CEO_Name:company[12], > CEO_Address_1:company[13], > CEO_Address_2:company[14], > CEO_City:company[15], > CEO_State:company[16], > CEO_Zip:company[17], > > Registered_Agent_Name:company[18], > Registered_Agent_Address_1:company[19], > Registered_Agent_Address_2:company[20], > Registered_Agent_City:company[21], > Registered_Agent_State:company[22], > Registered_Agent_Zip:company[23], > > Location_Name:company[24], > Location_Address_1:company[25], > Location_Address_2:company[26], > Location_City:company[27], > Location_State:company[28], > Location_Zip:company[29] > } > ); > > Each row is one node so it's as close to the raw data as possible. The > idea is loosely that these nodes will be linked with new nodes representing > people and addresses verified by reporters. > > This is what I got: > > +-------------------+ > | No data returned. | > +-------------------+ > Nodes created: 1964486 > Properties set: 58934580 > Labels added: 1964486 > 4550855 ms > > Some context information: > Neo4j Milestone Release 2.1.0-M01 > Windows 7 > java version "1.7.0_03" > > Best, > Aram > -- 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. -- 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.
