Importing data using Cypher shell

raj_choyal123 · June 2, 2024, 3:36pm

Hi,
I am trying to import using :source <> file name command (in cypher shell) for cypher file which contain around 200K (12 MB file) line of command for node creation and relationship. There is no syntax error. Its already close to 14 hours and still script is not completed. Most of the documentation only talks about CSV file upload but very few approach on cypher command file.

Is it correct way to create nodes and relationship, is there better way.
is there better way.
Is there any way to see some messages to see % completion.

Regards,
Rajesh Patel.

dana_canzano · June 2, 2024, 9:27pm

@raj_choyal123

a. what version of Neo4j ?
b. during these 14 hours if you run call dbms.listQueries(); does this report your queries being run?
c. is your last statement / all statements terminated by a ; character. for example if your file has

match (n) detach delete n;
create (n:Person {id:1});
match (n) return n

then as a result of no final ; cypher-shell has only processed the 1st 2 lines above, since each is terminated by a ; but the 3rd has no terminating ; and thus cypher-shell has not yet parsed/run

raj_choyal123 · June 4, 2024, 12:19pm

Hi Dana,

I am using version 5.19 version of db server. No I did not call "dbms.listQueries()" . I have only all CREATE statements, which basically create all nodes and relationship between them close to 200K nodes and same number of relationship. Same script work if I reduce the script to lesser number of nodes via browser. I am attaching sample file with all fake simulated data. This is exact sample only difference is I have reduced number of lines but having complete relationship.

CREATE (V1:Victim:Person{victim_id:'7587244',victim_name:'V7587244'})
CREATE (V2:Victim:Person{victim_id:'8587353',victim_name:'V8587353'})
CREATE (V3:Victim:Person{victim_id:'8543647',victim_name:'V8543647'})
CREATE (V4:Victim:Person{victim_id:'9360354',victim_name:'V9360354'})
CREATE (V5:Victim:Person{victim_id:'16770',victim_name:'V16770'})
CREATE (V6:Victim:Person{victim_id:'5056027',victim_name:'V5056027'})
CREATE (V7:Victim:Person{victim_id:'6701433',victim_name:'V6701433'})
CREATE (V8:Victim:Person{victim_id:'6058566',victim_name:'V6058566'})
CREATE (V9:Victim:Person{victim_id:'6582144',victim_name:'V6582144'})
CREATE (V10:Victim:Person{victim_id:'3393446',victim_name:'V3393446'})
CREATE (V11:Victim:Person{victim_id:'204134',victim_name:'V204134'})
CREATE (V12:Victim:Person{victim_id:'8242972',victim_name:'V8242972'})
CREATE (V13:Victim:Person{victim_id:'4975739',victim_name:'V4975739'})
CREATE (V14:Victim:Person{victim_id:'7928546',victim_name:'V7928546'})
CREATE (V15:Victim:Person{victim_id:'2246104',victim_name:'V2246104'})
CREATE (V16:Victim:Person{victim_id:'683283',victim_name:'V683283'})
CREATE (V17:Victim:Person{victim_id:'6852979',victim_name:'V6852979'})
CREATE (V18:Victim:Person{victim_id:'2810255',victim_name:'V2810255'})
CREATE (V19:Victim:Person{victim_id:'2434181',victim_name:'V2434181'})
CREATE (V20:Victim:Person{victim_id:'1149525',victim_name:'V1149525'})
CREATE (C1:Case:CyberFraud{crime_num:'KA_00000001',unit_id:'4965',amount_stolen:47621})
CREATE (C2:Case:CyberFraud{crime_num:'KA_00000002',unit_id:'6388',amount_stolen:48921})
CREATE (C3:Case:CyberFraud{crime_num:'KA_00000003',unit_id:'9969',amount_stolen:16631})
CREATE (C4:Case:CyberFraud{crime_num:'KA_00000004',unit_id:'5079',amount_stolen:27642})
CREATE (C5:Case:CyberFraud{crime_num:'KA_00000005',unit_id:'1824',amount_stolen:45828})
CREATE (C6:Case:CyberFraud{crime_num:'KA_00000006',unit_id:'7214',amount_stolen:36946})
CREATE (C7:Case:CyberFraud{crime_num:'KA_00000007',unit_id:'9347',amount_stolen:8587})
CREATE (C8:Case:CyberFraud{crime_num:'KA_00000008',unit_id:'6562',amount_stolen:2708})
CREATE (C9:Case:CyberFraud{crime_num:'KA_00000009',unit_id:'3116',amount_stolen:7072})
CREATE (C10:Case:CyberFraud{crime_num:'KA_00000010',unit_id:'7640',amount_stolen:18333})
CREATE (C11:Case:CyberFraud{crime_num:'KA_00000011',unit_id:'7769',amount_stolen:14628})
CREATE (C12:Case:CyberFraud{crime_num:'KA_00000012',unit_id:'6091',amount_stolen:30974})
CREATE (C13:Case:CyberFraud{crime_num:'KA_00000013',unit_id:'6266',amount_stolen:22494})
CREATE (C14:Case:CyberFraud{crime_num:'KA_00000014',unit_id:'4895',amount_stolen:25971})
CREATE (C15:Case:CyberFraud{crime_num:'KA_00000015',unit_id:'4192',amount_stolen:25599})
CREATE (C16:Case:CyberFraud{crime_num:'KA_00000016',unit_id:'6297',amount_stolen:1587})
CREATE (C17:Case:CyberFraud{crime_num:'KA_00000017',unit_id:'6984',amount_stolen:46231})
CREATE (C18:Case:CyberFraud{crime_num:'KA_00000018',unit_id:'8884',amount_stolen:26712})
CREATE (C19:Case:CyberFraud{crime_num:'KA_00000019',unit_id:'1369',amount_stolen:6745})
CREATE (C20:Case:CyberFraud{crime_num:'KA_00000020',unit_id:'8290',amount_stolen:23248})
CREATE (V1) - [:FILE_CASE]->(C1)
CREATE (V2) - [:FILE_CASE]->(C2)
CREATE (V3) - [:FILE_CASE]->(C3)
CREATE (V4) - [:FILE_CASE]->(C4)
CREATE (V5) - [:FILE_CASE]->(C5)
CREATE (V6) - [:FILE_CASE]->(C6)
CREATE (V7) - [:FILE_CASE]->(C7)
CREATE (V8) - [:FILE_CASE]->(C8)
CREATE (V9) - [:FILE_CASE]->(C9)
CREATE (V10) - [:FILE_CASE]->(C10)
CREATE (V11) - [:FILE_CASE]->(C11)
CREATE (V12) - [:FILE_CASE]->(C12)
CREATE (V13) - [:FILE_CASE]->(C13)
CREATE (V14) - [:FILE_CASE]->(C14)
CREATE (V15) - [:FILE_CASE]->(C15)
CREATE (V16) - [:FILE_CASE]->(C16)
CREATE (V17) - [:FILE_CASE]->(C17)
CREATE (V18) - [:FILE_CASE]->(C18)
CREATE (V19) - [:FILE_CASE]->(C19)
CREATE (V20) - [:FILE_CASE]->(C20)
CREATE (AV1:BankAccount:Victim{acc_num:'10015555679'})
CREATE (AV2:BankAccount:Victim{acc_num:'10022939366'})
CREATE (AV3:BankAccount:Victim{acc_num:'10031925193'})
CREATE (AV4:BankAccount:Victim{acc_num:'10045135235'})
CREATE (AV5:BankAccount:Victim{acc_num:'10008677516'})
CREATE (AV6:BankAccount:Victim{acc_num:'10023381029'})
CREATE (AV7:BankAccount:Victim{acc_num:'10041607824'})
CREATE (AV8:BankAccount:Victim{acc_num:'10022911435'})
CREATE (AV9:BankAccount:Victim{acc_num:'10041161300'})
CREATE (AV10:BankAccount:Victim{acc_num:'10023046822'})
CREATE (AV11:BankAccount:Victim{acc_num:'10049562233'})
CREATE (AV12:BankAccount:Victim{acc_num:'10033353860'})
CREATE (AV13:BankAccount:Victim{acc_num:'10038299601'})
CREATE (AV14:BankAccount:Victim{acc_num:'10043472629'})
CREATE (AV15:BankAccount:Victim{acc_num:'10049125424'})
CREATE (AV16:BankAccount:Victim{acc_num:'10030818968'})
CREATE (AV17:BankAccount:Victim{acc_num:'10019166826'})
CREATE (AV18:BankAccount:Victim{acc_num:'10046926809'})
CREATE (AV19:BankAccount:Victim{acc_num:'10031880287'})
CREATE (AV20:BankAccount:Victim{acc_num:'10033607462'})
CREATE (V1) - [:HOLDS_AC]->(AV1)
CREATE (V2) - [:HOLDS_AC]->(AV2)
CREATE (V3) - [:HOLDS_AC]->(AV3)
CREATE (V4) - [:HOLDS_AC]->(AV4)
CREATE (V5) - [:HOLDS_AC]->(AV5)
CREATE (V6) - [:HOLDS_AC]->(AV6)
CREATE (V7) - [:HOLDS_AC]->(AV7)
CREATE (V8) - [:HOLDS_AC]->(AV8)
CREATE (V9) - [:HOLDS_AC]->(AV9)
CREATE (V10) - [:HOLDS_AC]->(AV10)
CREATE (V11) - [:HOLDS_AC]->(AV11)
CREATE (V12) - [:HOLDS_AC]->(AV12)
CREATE (V13) - [:HOLDS_AC]->(AV13)
CREATE (V14) - [:HOLDS_AC]->(AV14)
CREATE (V15) - [:HOLDS_AC]->(AV15)
CREATE (V16) - [:HOLDS_AC]->(AV16)
CREATE (V17) - [:HOLDS_AC]->(AV17)
CREATE (V18) - [:HOLDS_AC]->(AV18)
CREATE (V19) - [:HOLDS_AC]->(AV19)
CREATE (V20) - [:HOLDS_AC]->(AV20)
CREATE (BIF1:Ifsc:BankAccount:Victim{ifsc_code:'29091'})
CREATE (BIF2:Ifsc:BankAccount:Victim{ifsc_code:'84300'})
CREATE (BIF3:Ifsc:BankAccount:Victim{ifsc_code:'11490'})
CREATE (BIF4:Ifsc:BankAccount:Victim{ifsc_code:'94993'})
CREATE (BIF5:Ifsc:BankAccount:Victim{ifsc_code:'21336'})
CREATE (BIF6:Ifsc:BankAccount:Victim{ifsc_code:'96269'})
CREATE (BIF7:Ifsc:BankAccount:Victim{ifsc_code:'51825'})
CREATE (BIF8:Ifsc:BankAccount:Victim{ifsc_code:'64964'})
CREATE (BIF9:Ifsc:BankAccount:Victim{ifsc_code:'85303'})
CREATE (BIF10:Ifsc:BankAccount:Victim{ifsc_code:'32711'})
CREATE (BIF11:Ifsc:BankAccount:Victim{ifsc_code:'19428'})
CREATE (BIF12:Ifsc:BankAccount:Victim{ifsc_code:'15428'})
CREATE (BIF13:Ifsc:BankAccount:Victim{ifsc_code:'60241'})
CREATE (BIF14:Ifsc:BankAccount:Victim{ifsc_code:'49145'})
CREATE (BIF15:Ifsc:BankAccount:Victim{ifsc_code:'15689'})
CREATE (BIF16:Ifsc:BankAccount:Victim{ifsc_code:'79828'})
CREATE (BIF17:Ifsc:BankAccount:Victim{ifsc_code:'39371'})
CREATE (BIF18:Ifsc:BankAccount:Victim{ifsc_code:'83128'})
CREATE (BIF19:Ifsc:BankAccount:Victim{ifsc_code:'71689'})
CREATE (BIF20:Ifsc:BankAccount:Victim{ifsc_code:'65670'})
CREATE (PIN7:Pincode:BankAccount:Victim{regst_addr_pin_code:'574227'})
CREATE (PIN1:Pincode:BankAccount:Victim{regst_addr_pin_code:'591102'})
CREATE (PIN2:Pincode:BankAccount:Victim{regst_addr_pin_code:'583213'})
CREATE (PIN3:Pincode:BankAccount:Victim{regst_addr_pin_code:'577204'})
CREATE (PIN4:Pincode:BankAccount:Victim{regst_addr_pin_code:'571123'})
CREATE (PIN5:Pincode:BankAccount:Victim{regst_addr_pin_code:'571602'})
CREATE (PIN6:Pincode:BankAccount:Victim{regst_addr_pin_code:'571127'})
CREATE (PIN8:Pincode:BankAccount:Victim{regst_addr_pin_code:'591112'})
CREATE (PIN9:Pincode:BankAccount:Victim{regst_addr_pin_code:'585302'})
CREATE (PIN10:Pincode:BankAccount:Victim{regst_addr_pin_code:'582118'})
CREATE (PIN11:Pincode:BankAccount:Victim{regst_addr_pin_code:'583284'})
CREATE (PIN12:Pincode:BankAccount:Victim{regst_addr_pin_code:'585223'})
CREATE (PIN13:Pincode:BankAccount:Victim{regst_addr_pin_code:'583122'})
CREATE (PIN14:Pincode:BankAccount:Victim{regst_addr_pin_code:'585228'})
CREATE (PIN15:Pincode:BankAccount:Victim{regst_addr_pin_code:'572106'})
CREATE (PIN16:Pincode:BankAccount:Victim{regst_addr_pin_code:'585104'})
CREATE (PIN17:Pincode:BankAccount:Victim{regst_addr_pin_code:'585416'})
CREATE (PIN18:Pincode:BankAccount:Victim{regst_addr_pin_code:'580011'})
CREATE (PIN19:Pincode:BankAccount:Victim{regst_addr_pin_code:'563103'})
CREATE (PIN20:Pincode:BankAccount:Victim{regst_addr_pin_code:'581450'})
CREATE (PIN_STATE1:PinState:BankAccount:Victim{regst_pin_state:'Karnataka Circle'})
CREATE (PIN_STATE2:PinState:BankAccount:Victim{regst_pin_state:'Karnataka Circle'})
CREATE (PIN_STATE3:PinState:BankAccount:Victim{regst_pin_state:'Karnataka Circle'})
CREATE (PIN_STATE4:PinState:BankAccount:Victim{regst_pin_state:'Karnataka Circle'})
CREATE (PIN_STATE5:PinState:BankAccount:Victim{regst_pin_state:'Karnataka Circle'})
CREATE (PIN_STATE6:PinState:BankAccount:Victim{regst_pin_state:'Karnataka Circle'})
CREATE (PIN_STATE7:PinState:BankAccount:Victim{regst_pin_state:'Karnataka Circle'})
CREATE (PIN_STATE8:PinState:BankAccount:Victim{regst_pin_state:'Karnataka Circle'})
CREATE (PIN_STATE9:PinState:BankAccount:Victim{regst_pin_state:'Karnataka Circle'})
CREATE (PIN_STATE10:PinState:BankAccount:Victim{regst_pin_state:'Karnataka Circle'})
CREATE (PIN_STATE11:PinState:BankAccount:Victim{regst_pin_state:'Karnataka Circle'})
CREATE (PIN_STATE12:PinState:BankAccount:Victim{regst_pin_state:'Karnataka Circle'})
CREATE (PIN_STATE13:PinState:BankAccount:Victim{regst_pin_state:'Karnataka Circle'})
CREATE (PIN_STATE14:PinState:BankAccount:Victim{regst_pin_state:'Karnataka Circle'})
CREATE (PIN_STATE15:PinState:BankAccount:Victim{regst_pin_state:'Karnataka Circle'})
CREATE (PIN_STATE16:PinState:BankAccount:Victim{regst_pin_state:'Karnataka Circle'})
CREATE (PIN_STATE17:PinState:BankAccount:Victim{regst_pin_state:'Karnataka Circle'})
CREATE (PIN_STATE18:PinState:BankAccount:Victim{regst_pin_state:'Karnataka Circle'})
CREATE (PIN_STATE19:PinState:BankAccount:Victim{regst_pin_state:'Karnataka Circle'})
CREATE (PIN_STATE20:PinState:BankAccount:Victim{regst_pin_state:'Karnataka Circle'})
CREATE (PIN_DIV1:PinDivision:BankAccount:Victim{regst_pin_division:'Belagavi Division'})
CREATE (PIN_DIV2:PinDivision:BankAccount:Victim{regst_pin_division:'Ballari Division'})
CREATE (PIN_DIV3:PinDivision:BankAccount:Victim{regst_pin_division:'Shivamogga Division'})
CREATE (PIN_DIV4:PinDivision:BankAccount:Victim{regst_pin_division:'Nanjangud Division'})
CREATE (PIN_DIV5:PinDivision:BankAccount:Victim{regst_pin_division:'Mysuru Division'})
CREATE (PIN_DIV6:PinDivision:BankAccount:Victim{regst_pin_division:'Nanjangud Division'})
CREATE (PIN_DIV7:PinDivision:BankAccount:Victim{regst_pin_division:'Puttur Division'})
CREATE (PIN_DIV8:PinDivision:BankAccount:Victim{regst_pin_division:'Belagavi Division'})
CREATE (PIN_DIV9:PinDivision:BankAccount:Victim{regst_pin_division:'Kalaburagi Division'})
CREATE (PIN_DIV10:PinDivision:BankAccount:Victim{regst_pin_division:'Gadag Division'})
CREATE (PIN_DIV11:PinDivision:BankAccount:Victim{regst_pin_division:'Gadag Division'})
CREATE (PIN_DIV12:PinDivision:BankAccount:Victim{regst_pin_division:'Kalaburagi Division'})
CREATE (PIN_DIV13:PinDivision:BankAccount:Victim{regst_pin_division:'Ballari Division'})
CREATE (PIN_DIV14:PinDivision:BankAccount:Victim{regst_pin_division:'Kalaburagi Division'})
CREATE (PIN_DIV15:PinDivision:BankAccount:Victim{regst_pin_division:'Tumakuru Division'})
CREATE (PIN_DIV16:PinDivision:BankAccount:Victim{regst_pin_division:'Kalaburagi Division'})
CREATE (PIN_DIV17:PinDivision:BankAccount:Victim{regst_pin_division:'Bidar Division'})
CREATE (PIN_DIV18:PinDivision:BankAccount:Victim{regst_pin_division:'Dharwad Division'})
CREATE (PIN_DIV19:PinDivision:BankAccount:Victim{regst_pin_division:'Kolar Division'})
CREATE (PIN_DIV20:PinDivision:BankAccount:Victim{regst_pin_division:'Sirsi Division'})
CREATE (PIN_OFF1:PinOffice:BankAccount:Victim{regst_pin_office:'Amtur B.O'})
CREATE (PIN_OFF2:PinOffice:BankAccount:Victim{regst_pin_office:'Arasanahalu B.O'})
CREATE (PIN_OFF3:PinOffice:BankAccount:Victim{regst_pin_office:'Abbalagere B.O'})
CREATE (PIN_OFF4:PinOffice:BankAccount:Victim{regst_pin_office:'Balachavadi B.O'})
CREATE (PIN_OFF5:PinOffice:BankAccount:Victim{regst_pin_office:'Basavarajapura B.O'})
CREATE (PIN_OFF6:PinOffice:BankAccount:Victim{regst_pin_office:'Amachavadi B.O'})
CREATE (PIN_OFF7:PinOffice:BankAccount:Victim{regst_pin_office:'Alangar B.O'})
CREATE (PIN_OFF8:PinOffice:BankAccount:Victim{regst_pin_office:'Ambadgatti B.O'})
CREATE (PIN_OFF9:PinOffice:BankAccount:Victim{regst_pin_office:'Alund Bazar B.O'})
CREATE (PIN_OFF10:PinOffice:BankAccount:Victim{regst_pin_office:'Bagewadi B.O'})
CREATE (PIN_OFF11:PinOffice:BankAccount:Victim{regst_pin_office:'Ballutgi B.O'})
CREATE (PIN_OFF12:PinOffice:BankAccount:Victim{regst_pin_office:'Adilapur B.O'})
CREATE (PIN_OFF13:PinOffice:BankAccount:Victim{regst_pin_office:'Balakundi B.O'})
CREATE (PIN_OFF14:PinOffice:BankAccount:Victim{regst_pin_office:'Bhankur B.O'})
CREATE (PIN_OFF15:PinOffice:BankAccount:Victim{regst_pin_office:'Arakere B.O'})
CREATE (PIN_OFF16:PinOffice:BankAccount:Victim{regst_pin_office:'Asta B.O'})
CREATE (PIN_OFF17:PinOffice:BankAccount:Victim{regst_pin_office:'Alwai B.O'})
CREATE (PIN_OFF18:PinOffice:BankAccount:Victim{regst_pin_office:'Dharwad High Court S.O'})
CREATE (PIN_OFF19:PinOffice:BankAccount:Victim{regst_pin_office:'Chamarahalli B.O'})
CREATE (PIN_OFF20:PinOffice:BankAccount:Victim{regst_pin_office:'Hegnoor B.O'})
CREATE (MOB1:Mobile:BankAccount:Victim{regist_mobile:'1001679992'})
CREATE (MOB2:Mobile:BankAccount:Victim{regist_mobile:'1005545227'})
CREATE (MOB3:Mobile:BankAccount:Victim{regist_mobile:'1008131268'})
CREATE (MOB4:Mobile:BankAccount:Victim{regist_mobile:'1004308150'})
CREATE (MOB5:Mobile:BankAccount:Victim{regist_mobile:'1005149245'})
CREATE (MOB6:Mobile:BankAccount:Victim{regist_mobile:'1000099125'})
CREATE (MOB7:Mobile:BankAccount:Victim{regist_mobile:'1007114225'})
CREATE (MOB8:Mobile:BankAccount:Victim{regist_mobile:'1009070339'})
CREATE (MOB9:Mobile:BankAccount:Victim{regist_mobile:'1003575859'})
CREATE (MOB10:Mobile:BankAccount:Victim{regist_mobile:'1002476728'})
CREATE (MOB11:Mobile:BankAccount:Victim{regist_mobile:'1007734703'})
CREATE (MOB12:Mobile:BankAccount:Victim{regist_mobile:'1001147394'})
CREATE (MOB13:Mobile:BankAccount:Victim{regist_mobile:'1009202806'})
CREATE (MOB14:Mobile:BankAccount:Victim{regist_mobile:'1000521110'})
CREATE (MOB15:Mobile:BankAccount:Victim{regist_mobile:'1000048704'})
CREATE (MOB16:Mobile:BankAccount:Victim{regist_mobile:'1006731968'})
CREATE (MOB17:Mobile:BankAccount:Victim{regist_mobile:'1002164561'})
CREATE (MOB18:Mobile:BankAccount:Victim{regist_mobile:'1000561223'})
CREATE (MOB19:Mobile:BankAccount:Victim{regist_mobile:'1002806415'})
CREATE (MOB20:Mobile:BankAccount:Victim{regist_mobile:'1001947797'})
CREATE (Email1:Email:BankAccount:Victim{regst_email_address:'V7587244@xyz.com'})
CREATE (Email2:Email:BankAccount:Victim{regst_email_address:'V8587353@xyz.com'})
CREATE (Email3:Email:BankAccount:Victim{regst_email_address:'V8543647@xyz.com'})
CREATE (Email4:Email:BankAccount:Victim{regst_email_address:'V9360354@xyz.com'})
CREATE (Email5:Email:BankAccount:Victim{regst_email_address:'V16770@xyz.com'})
CREATE (Email6:Email:BankAccount:Victim{regst_email_address:'V5056027@xyz.com'})
CREATE (Email7:Email:BankAccount:Victim{regst_email_address:'V6701433@xyz.com'})
CREATE (Email8:Email:BankAccount:Victim{regst_email_address:'V6058566@xyz.com'})
CREATE (Email9:Email:BankAccount:Victim{regst_email_address:'V6582144@xyz.com'})
CREATE (Email10:Email:BankAccount:Victim{regst_email_address:'V3393446@xyz.com'})
CREATE (Email11:Email:BankAccount:Victim{regst_email_address:'V204134@xyz.com'})
CREATE (Email12:Email:BankAccount:Victim{regst_email_address:'V8242972@xyz.com'})
CREATE (Email13:Email:BankAccount:Victim{regst_email_address:'V4975739@xyz.com'})
CREATE (Email14:Email:BankAccount:Victim{regst_email_address:'V7928546@xyz.com'})
CREATE (Email15:Email:BankAccount:Victim{regst_email_address:'V2246104@xyz.com'})
CREATE (Email16:Email:BankAccount:Victim{regst_email_address:'V683283@xyz.com'})
CREATE (Email17:Email:BankAccount:Victim{regst_email_address:'V6852979@xyz.com'})
CREATE (Email18:Email:BankAccount:Victim{regst_email_address:'V2810255@xyz.com'})
CREATE (Email19:Email:BankAccount:Victim{regst_email_address:'V2434181@xyz.com'})
CREATE (Email20:Email:BankAccount:Victim{regst_email_address:'V1149525@xyz.com'})
CREATE (AV1) - [:MAPPED_TO_IFSC]->(BIF1)
CREATE(AV1) - [:MAPPED_TO_PIN]->(PIN1)
CREATE(AV1) - [:MAPPED_TO_PIN_STATE]->(PIN_STATE1)
CREATE(AV1) - [:MAPPED_TO_PIN_DIVISION]->(PIN_DIV1)
CREATE(AV1) - [:MAPPED_TO_PIN_OFFICE]->(PIN_OFF1)
CREATE(AV1) - [:MAPPED_TO_MOBILE]->(MOB1)
CREATE(AV1) - [:MAPPED_TO_EMAIL]->(Email1)

CREATE (AV2) - [:MAPPED_TO_IFSC]->(BIF2)
CREATE(AV2) - [:MAPPED_TO_PIN]->(PIN2)
CREATE(AV2) - [:MAPPED_TO_PIN_STATE]->(PIN_STATE2)
CREATE(AV2) - [:MAPPED_TO_PIN_DIVISION]->(PIN_DIV2)
CREATE(AV2) - [:MAPPED_TO_PIN_OFFICE]->(PIN_OFF2)
CREATE(AV2) - [:MAPPED_TO_MOBILE]->(MOB2)
CREATE(AV2) - [:MAPPED_TO_EMAIL]->(Email2)

CREATE (AV3) - [:MAPPED_TO_IFSC]->(BIF3)
CREATE(AV3) - [:MAPPED_TO_PIN]->(PIN3)
CREATE(AV3) - [:MAPPED_TO_PIN_STATE]->(PIN_STATE3)
CREATE(AV3) - [:MAPPED_TO_PIN_DIVISION]->(PIN_DIV3)
CREATE(AV3) - [:MAPPED_TO_PIN_OFFICE]->(PIN_OFF3)
CREATE(AV3) - [:MAPPED_TO_MOBILE]->(MOB3)
CREATE(AV3) - [:MAPPED_TO_EMAIL]->(Email3)

CREATE (AV4) - [:MAPPED_TO_IFSC]->(BIF4)
CREATE(AV4) - [:MAPPED_TO_PIN]->(PIN4)
CREATE(AV4) - [:MAPPED_TO_PIN_STATE]->(PIN_STATE4)
CREATE(AV4) - [:MAPPED_TO_PIN_DIVISION]->(PIN_DIV4)
CREATE(AV4) - [:MAPPED_TO_PIN_OFFICE]->(PIN_OFF4)
CREATE(AV4) - [:MAPPED_TO_MOBILE]->(MOB4)
CREATE(AV4) - [:MAPPED_TO_EMAIL]->(Email4)

CREATE (AV5) - [:MAPPED_TO_IFSC]->(BIF5)
CREATE(AV5) - [:MAPPED_TO_PIN]->(PIN5)
CREATE(AV5) - [:MAPPED_TO_PIN_STATE]->(PIN_STATE5)
CREATE(AV5) - [:MAPPED_TO_PIN_DIVISION]->(PIN_DIV5)
CREATE(AV5) - [:MAPPED_TO_PIN_OFFICE]->(PIN_OFF5)
CREATE(AV5) - [:MAPPED_TO_MOBILE]->(MOB5)
CREATE(AV5) - [:MAPPED_TO_EMAIL]->(Email5)

CREATE (AV6) - [:MAPPED_TO_IFSC]->(BIF6)
CREATE(AV6) - [:MAPPED_TO_PIN]->(PIN6)
CREATE(AV6) - [:MAPPED_TO_PIN_STATE]->(PIN_STATE6)
CREATE(AV6) - [:MAPPED_TO_PIN_DIVISION]->(PIN_DIV6)
CREATE(AV6) - [:MAPPED_TO_PIN_OFFICE]->(PIN_OFF6)
CREATE(AV6) - [:MAPPED_TO_MOBILE]->(MOB6)
CREATE(AV6) - [:MAPPED_TO_EMAIL]->(Email6)

CREATE (AV7) - [:MAPPED_TO_IFSC]->(BIF7)
CREATE(AV7) - [:MAPPED_TO_PIN]->(PIN7)
CREATE(AV7) - [:MAPPED_TO_PIN_STATE]->(PIN_STATE7)
CREATE(AV7) - [:MAPPED_TO_PIN_DIVISION]->(PIN_DIV7)
CREATE(AV7) - [:MAPPED_TO_PIN_OFFICE]->(PIN_OFF7)
CREATE(AV7) - [:MAPPED_TO_MOBILE]->(MOB7)
CREATE(AV7) - [:MAPPED_TO_EMAIL]->(Email7)

CREATE (AV8) - [:MAPPED_TO_IFSC]->(BIF8)
CREATE(AV8) - [:MAPPED_TO_PIN]->(PIN8)
CREATE(AV8) - [:MAPPED_TO_PIN_STATE]->(PIN_STATE8)
CREATE(AV8) - [:MAPPED_TO_PIN_DIVISION]->(PIN_DIV8)
CREATE(AV8) - [:MAPPED_TO_PIN_OFFICE]->(PIN_OFF8)
CREATE(AV8) - [:MAPPED_TO_MOBILE]->(MOB8)
CREATE(AV8) - [:MAPPED_TO_EMAIL]->(Email8)

CREATE (AV9) - [:MAPPED_TO_IFSC]->(BIF9)
CREATE(AV9) - [:MAPPED_TO_PIN]->(PIN9)
CREATE(AV9) - [:MAPPED_TO_PIN_STATE]->(PIN_STATE9)
CREATE(AV9) - [:MAPPED_TO_PIN_DIVISION]->(PIN_DIV9)
CREATE(AV9) - [:MAPPED_TO_PIN_OFFICE]->(PIN_OFF9)
CREATE(AV9) - [:MAPPED_TO_MOBILE]->(MOB9)
CREATE(AV9) - [:MAPPED_TO_EMAIL]->(Email9)

CREATE (AV10) - [:MAPPED_TO_IFSC]->(BIF10)
CREATE(AV10) - [:MAPPED_TO_PIN]->(PIN10)
CREATE(AV10) - [:MAPPED_TO_PIN_STATE]->(PIN_STATE10)
CREATE(AV10) - [:MAPPED_TO_PIN_DIVISION]->(PIN_DIV10)
CREATE(AV10) - [:MAPPED_TO_PIN_OFFICE]->(PIN_OFF10)
CREATE(AV10) - [:MAPPED_TO_MOBILE]->(MOB10)
CREATE(AV10) - [:MAPPED_TO_EMAIL]->(Email10)

CREATE (AV11) - [:MAPPED_TO_IFSC]->(BIF11)
CREATE(AV11) - [:MAPPED_TO_PIN]->(PIN11)
CREATE(AV11) - [:MAPPED_TO_PIN_STATE]->(PIN_STATE11)
CREATE(AV11) - [:MAPPED_TO_PIN_DIVISION]->(PIN_DIV11)
CREATE(AV11) - [:MAPPED_TO_PIN_OFFICE]->(PIN_OFF11)
CREATE(AV11) - [:MAPPED_TO_MOBILE]->(MOB11)
CREATE(AV11) - [:MAPPED_TO_EMAIL]->(Email11)

CREATE (AV12) - [:MAPPED_TO_IFSC]->(BIF12)
CREATE(AV12) - [:MAPPED_TO_PIN]->(PIN12)
CREATE(AV12) - [:MAPPED_TO_PIN_STATE]->(PIN_STATE12)
CREATE(AV12) - [:MAPPED_TO_PIN_DIVISION]->(PIN_DIV12)
CREATE(AV12) - [:MAPPED_TO_PIN_OFFICE]->(PIN_OFF12)
CREATE(AV12) - [:MAPPED_TO_MOBILE]->(MOB12)
CREATE(AV12) - [:MAPPED_TO_EMAIL]->(Email12)

CREATE (AV13) - [:MAPPED_TO_IFSC]->(BIF13)
CREATE(AV13) - [:MAPPED_TO_PIN]->(PIN13)
CREATE(AV13) - [:MAPPED_TO_PIN_STATE]->(PIN_STATE13)
CREATE(AV13) - [:MAPPED_TO_PIN_DIVISION]->(PIN_DIV13)
CREATE(AV13) - [:MAPPED_TO_PIN_OFFICE]->(PIN_OFF13)
CREATE(AV13) - [:MAPPED_TO_MOBILE]->(MOB13)
CREATE(AV13) - [:MAPPED_TO_EMAIL]->(Email13)

CREATE (AV14) - [:MAPPED_TO_IFSC]->(BIF14)
CREATE(AV14) - [:MAPPED_TO_PIN]->(PIN14)
CREATE(AV14) - [:MAPPED_TO_PIN_STATE]->(PIN_STATE14)
CREATE(AV14) - [:MAPPED_TO_PIN_DIVISION]->(PIN_DIV14)
CREATE(AV14) - [:MAPPED_TO_PIN_OFFICE]->(PIN_OFF14)
CREATE(AV14) - [:MAPPED_TO_MOBILE]->(MOB14)
CREATE(AV14) - [:MAPPED_TO_EMAIL]->(Email14)

CREATE (AV15) - [:MAPPED_TO_IFSC]->(BIF15)
CREATE(AV15) - [:MAPPED_TO_PIN]->(PIN15)
CREATE(AV15) - [:MAPPED_TO_PIN_STATE]->(PIN_STATE15)
CREATE(AV15) - [:MAPPED_TO_PIN_DIVISION]->(PIN_DIV15)
CREATE(AV15) - [:MAPPED_TO_PIN_OFFICE]->(PIN_OFF15)
CREATE(AV15) - [:MAPPED_TO_MOBILE]->(MOB15)
CREATE(AV15) - [:MAPPED_TO_EMAIL]->(Email15)

CREATE (AV16) - [:MAPPED_TO_IFSC]->(BIF16)
CREATE(AV16) - [:MAPPED_TO_PIN]->(PIN16)
CREATE(AV16) - [:MAPPED_TO_PIN_STATE]->(PIN_STATE16)
CREATE(AV16) - [:MAPPED_TO_PIN_DIVISION]->(PIN_DIV16)
CREATE(AV16) - [:MAPPED_TO_PIN_OFFICE]->(PIN_OFF16)
CREATE(AV16) - [:MAPPED_TO_MOBILE]->(MOB16)
CREATE(AV16) - [:MAPPED_TO_EMAIL]->(Email16)

CREATE (AV17) - [:MAPPED_TO_IFSC]->(BIF17)
CREATE(AV17) - [:MAPPED_TO_PIN]->(PIN17)
CREATE(AV17) - [:MAPPED_TO_PIN_STATE]->(PIN_STATE17)
CREATE(AV17) - [:MAPPED_TO_PIN_DIVISION]->(PIN_DIV17)
CREATE(AV17) - [:MAPPED_TO_PIN_OFFICE]->(PIN_OFF17)
CREATE(AV17) - [:MAPPED_TO_MOBILE]->(MOB17)
CREATE(AV17) - [:MAPPED_TO_EMAIL]->(Email17)

CREATE (AV18) - [:MAPPED_TO_IFSC]->(BIF18)
CREATE(AV18) - [:MAPPED_TO_PIN]->(PIN18)
CREATE(AV18) - [:MAPPED_TO_PIN_STATE]->(PIN_STATE18)
CREATE(AV18) - [:MAPPED_TO_PIN_DIVISION]->(PIN_DIV18)
CREATE(AV18) - [:MAPPED_TO_PIN_OFFICE]->(PIN_OFF18)
CREATE(AV18) - [:MAPPED_TO_MOBILE]->(MOB18)
CREATE(AV18) - [:MAPPED_TO_EMAIL]->(Email18)

CREATE (AV19) - [:MAPPED_TO_IFSC]->(BIF19)
CREATE(AV19) - [:MAPPED_TO_PIN]->(PIN19)
CREATE(AV19) - [:MAPPED_TO_PIN_STATE]->(PIN_STATE19)
CREATE(AV19) - [:MAPPED_TO_PIN_DIVISION]->(PIN_DIV19)
CREATE(AV19) - [:MAPPED_TO_PIN_OFFICE]->(PIN_OFF19)
CREATE(AV19) - [:MAPPED_TO_MOBILE]->(MOB19)
CREATE(AV19) - [:MAPPED_TO_EMAIL]->(Email19)

CREATE (AV20) - [:MAPPED_TO_IFSC]->(BIF20)
CREATE(AV20) - [:MAPPED_TO_PIN]->(PIN20)
CREATE(AV20) - [:MAPPED_TO_PIN_STATE]->(PIN_STATE20)
CREATE(AV20) - [:MAPPED_TO_PIN_DIVISION]->(PIN_DIV20)
CREATE(AV20) - [:MAPPED_TO_PIN_OFFICE]->(PIN_OFF20)
CREATE(AV20) - [:MAPPED_TO_MOBILE]->(MOB20)
CREATE(AV20) - [:MAPPED_TO_EMAIL]->(Email20)

Regards,
Rajesh

dana_canzano · June 4, 2024, 12:34pm

@raj_choyal123

and yet none of the CREATE statements are terminated by a ;. Is that expected? You will have a single transaction which then attempts to committ 200k new node creations?

raj_choyal123 · June 7, 2024, 4:29am

Thanks a ton dana, it worked flawless. Now, I am creating much bigger script to populate the database.

Topic		Replies	Views
Create relationship too slow for existing nodes using cypher-shell Import / Export performance , cypher , relationship , import	0	245	July 21, 2021
Problems importing relationships Cypher cypher , csv	9	2998	February 3, 2019
Facing CSV data load issue using Neo4j-Admin import command Cypher cypher , import	1	260	March 2, 2021
Importing relationships from multiple csv file Import / Export performance , load-csv	12	3146	June 5, 2020
Csv import of 2 nodes works, but only one node is there Desktop	3	23	August 2, 2024

Importing data using Cypher shell

Related topics