The import for your sample data file works fine. Can you share your full csv file?
Michael Am 19.06.2014 um 13:07 schrieb Pavan Kumar <[email protected]>: > Hi, > > I have used following cypher statements for importing CSV file which has > 35000 records. The below statements executes for some time and gives me error > "Unknown error". I am using neo4j 2.1.2 version on windows (8GB RAM). > Attached is the sample CSV file. The main CSV file has some empty fields, > does it create any problem?? > Can any one help me in this regard > ---------------------------------------------------------------------------------------- > create constraint on (uniprotid:Uniprotid) assert uniprotid.uniprotid is > unique; > > create index on :Uniprottitle(Uniprot_title); > > create index on :Gene_Name(genename); > > create index on :GenBank_Protein(GenBank_protein_id); > > create index on :PDBID(PDBid); > > create index on :Geneatlasid(Geneatlas); > > create index on :HGNCid(hgnc); > > create index on :Species(Species); > > create index on :Genecardid(GeneCard); > > USING PERIODIC COMMIT 10000 > LOAD CSV WITH HEADERS FROM > "file:D:/Graph_Database/DrugBank_database/DrugbankFull_Database1.csv" > AS csvimport > merge (uniprotid:Uniprotid{uniprotid: csvimport.UniProt_ID}) > merge (Uniprotname:UniprotName{Name:csvimport.Name, Uniprot_title: > csvimport.Uniprot_Title}) ON CREATE SET > uniprotid.Name=csvimport.Name,uniprotid.Uniprot_title=csvimport.Uniprot_Title > merge (genename:Gene_Name{genename: csvimport.Gene_Name}) > merge (Genbank_prtn:GenBank_Protein{GenBank_protein_id: > csvimport.GenBank_Protein_ID}) > merge (Genbank_gene:GenBank_Gene{GenBank_gene_id: csvimport.GenBank_Gene_ID}) > merge (pdbid:PDBID{PDBid: csvimport.PDB_ID}) > merge (geneatlas:Geneatlasid{Geneatlas: csvimport.GenAtlas_ID}) > merge (HGNC:HGNCid{hgnc: csvimport.HGNC_ID}) > merge (species:Species{Species: csvimport.Species}) > merge (genecard:Genecardid{Genecard: csvimport.GeneCard_ID}) > merge (drugid:DrugID{DrugID: csvimport.Drug_IDs}) > merge (uniprotid)-[:Name_Title]->(uniprotname) > merge (uniprotid)-[:Genename]->(genename) > merge (uniprotid)-[:GenBank_ProteinID]->(Genbank_prtn) > merge (uniprotid)-[:GenBank_GeneID]->(Genbank_gene) > merge (uniprotid)-[:PDBID]->(pdbid) > merge (uniprotid)-[:GeneatlasID]->(geneatlas) > merge (uniprotid)-[:HGNCID]->(HGNC) > merge (uniprotid)-[:Species]->(species) > merge (uniprotid)-[:GenecardID]->(genecard) > merge (uniprotid)-[:DrugID]->(drugid) > merge (species)-[:Related_to]->(uniprotid) > -------------------------------------------------------------------------------- > -- > > Thanks & Regards, > Pavan Kumar > > > -- > 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. > <SAmple_Drugbank.csv> -- 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.
