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.
Name,Gene_Name,GenBank_Protein_ID,GenBank_Gene_ID,UniProt_ID,Uniprot_Title,PDB_ID,GeneCard_ID,GenAtlas_ID,HGNC_ID,Species,Drug_IDs,
Corticosteroid-binding globulin,SERPINA6,179971,J02943,P08185,CBG_HUMAN,,SERPINA6,SERPINA6,HGNC:1540,Human,DB00180; DB00240; DB00253; DB00324; DB00394; DB00588; DB00591; DB00596; DB00620; DB00648; DB00663; DB00846; DB00860; DB00896; DB01047; DB01384; DB01410; DB05688; DB07886,
Retinol-binding protein 4,RBP4,35897,X00129,P02753,RET4_HUMAN,,RBP4,RBP4,HGNC:9922,Human,DB00162; DB01770; DB03917; DB05076; DB06985,
Transthyretin,TTR,189582,K02091,P02766,TTHY_HUMAN,,TTR,TTR,HGNC:12405,Human,DB00255; DB00279; DB00451; DB00586; DB00861; DB01093; DB01583; DB01645; DB01751; DB01838; DB02179; DB02266; DB02417; DB02698; DB02709; DB03167; DB03239; DB03346; DB03682; DB04474; DB04674; DB04756; DB05235; DB05352; DB06885; DB06907; DB06935; DB07047; DB07176; DB07201; DB07240; DB07282; DB07693; DB07694; DB07695; DB07753; DB07775; DB07962; DB07963; DB08100; DB08101; DB08102; DB08103; DB08104; DB08205; DB08206; DB08207,
Transcobalamin-2,TCN2,339196,M60396,P20062,TCO2_HUMAN,,TCN2,TCN2,HGNC:11653,Human,DB00200,
Retinol-binding protein 2,RBP2,535390,U13831,P50120,RET2_HUMAN,,RBP2,RBP2,HGNC:9920,Human,DB00162,
Cellular retinoic acid-binding protein 1,CRABP1,241542,S74445,P29762,RABP1_HUMAN,,CRABP1,CRABP1,HGNC:2338,Human,DB00523; DB00926; DB03873,
Serotransferrin,TF,339453,M12530,P02787,TRFE_HUMAN,,TF,TF,HGNC:11740,Human,DB00893; DB01294; DB05260,
Serum albumin,ALB,28590,V00494,P02768,ALBU_HUMAN,,ALB,ALB,HGNC:399,Human,DB00070; DB00137; DB00177; DB00228; DB00252; DB00274; DB00279; DB00317; DB00321; DB00328; DB00334; DB00364; DB00412; DB00415; DB00430; DB00451; DB00454; DB00456; DB00459; DB00472; DB00477; DB00482; DB00495; DB00530; DB00540; DB00544; DB00554; DB00563; DB00567; DB00573; DB00576; DB00586; DB00605; DB00619; DB00624; DB00635; DB00655; DB00678; DB00682; DB00688; DB00695; DB00712; DB00717; DB00731; DB00743; DB00749; DB00753; DB00759; DB00762; DB00776; DB00783; DB00788; DB00802; DB00815; DB00818; DB00829; DB00861; DB00864; DB00903; DB00912; DB00931; DB00936; DB00945; DB00946; DB00995; DB01009; DB01015; DB01016; DB01032; DB01044; DB01050; DB01056; DB01068; DB01098; DB01120; DB01147; DB01159; DB01183; DB01189; DB01197; DB01212; DB01232; DB01236; DB01242; DB01294; DB01307; DB01320; DB01327; DB01328; DB01329; DB01330; DB01396; DB01397; DB01418; DB01581; DB01582; DB01583; DB01587; DB01614; DB01621; DB01622; DB01623; DB03193; DB03585; DB03600; DB03796; DB04224; DB04557; DB04574; DB04711; DB04855; DB05294; DB05521; DB05812,
Retinoid-binding protein 7,RBP7,24559768,AY145438,Q96R05,RET7_HUMAN,,RBP7,RBP7,HGNC:30316,Human,DB00162,
Thyroxine-binding globulin,SERPINA7,338697,M14091,P05543,THBG_HUMAN,,SERPINA7,SERPINA7,HGNC:11583,Human,DB00279; DB00451; DB01583; DB05235,
Alpha-tocopherol transfer protein,TTPA,699601,D49488,P49638,TTPA_HUMAN,,TTPA,TTPA,HGNC:12404,Human,DB00163; DB02080,
Retinol-binding protein 5,RBP5,13447447,AY007436,P82980,RET5_HUMAN,,RBP5,RBP5,HGNC:15847,Human,DB00162,
Sex hormone-binding globulin,SHBG,296673,X16349,P04278,SHBG_HUMAN,,SHBG,SHBG,HGNC:10839,Human,DB00624; DB00648; DB00717; DB00741; DB00783; DB00858; DB01185; DB01406; DB02342; DB02901; DB03882; DB03926; DB04574; DB05275; DB06710,
Cellular retinoic acid-binding protein 2,CRABP2,181026,M68867,P29373,RABP2_HUMAN,,CRABP2,CRABP2,HGNC:2339,Human,DB00523; DB08127; DB08455; DB08467,
Alpha-1-acid glycoprotein 1,ORM1,757907,X02544,P02763,A1AG1_HUMAN,,ORM1,ORM1,HGNC:8498,Human,DB00280; DB00317; DB00321; DB00334; DB00454; DB00457; DB00458; DB00472; DB00482; DB00530; DB00540; DB00543; DB00571; DB00590; DB00619; DB00656; DB00682; DB00706; DB00731; DB00802; DB00864; DB00908; DB00934; DB00946; DB01142; DB01151; DB01156; DB01232; DB01359; DB01418; DB01426; DB01429; DB04821; DB05294; DB05521; DB05812; DB08820; DB08828; DB08860; DB08881; DB08893; DB08907,
"Solute carrier family 2, facilitated glucose transporter member 1",SLC2A1,183303,K03195,P11166,GTR1_HUMAN,,SLC2A1,SLC2A1,HGNC:11005,Human,DB00292,
Vitamin D-binding protein,GC,639896,L10641,P02774,VTDB_HUMAN,,GC,GC,HGNC:4187,Human,DB00169; DB01436; DB04224,
"Fatty acid-binding protein, adipocyte",FABP4,178347,J02874,P15090,FABP4_HUMAN,,FABP4,FABP4,HGNC:3559,Human,DB02153; DB02776; DB03009; DB03766; DB03796; DB03851; DB04224; DB04437; DB04474; DB04557; DB07283; DB07945; DB08607,
"Fatty acid-binding protein, heart",FABP3,31293,X56549,P05413,FABPH_HUMAN,,FABP3,FABP3,HGNC:3557,Human,DB03193; DB03796; DB04224,
"Fatty acid-binding protein, brain",FABP7,2632065,AJ002962,O15540,FABP7_HUMAN,,FABP7,FABP7,HGNC:3562,Human,DB00132; DB00154; DB00159; DB03756; DB04224,
"Fatty acid-binding protein, epidermal",FABP5,182354,M94856,Q01469,FABP5_HUMAN,,FABP5,FABP5,HGNC:3560,Human,DB03796,
,,,,,,,,,,,,
,,,,,,,,,,,,
,,,,,,,,,,,,
,,,,,,,,,,,,
