Node and relationship creation

Neo4j Graph Platform Cypher
1

Hi ,
I am just a beginner and trying to understand graph database. I have trying to run following command.

CREATE (a:AccountHolder:Victim {name: 'Rajesh Patel', dob: '1/1/1070'})
CREATE (b:BankAccount:Victim {account_num: '111111111111'})
CREATE (e:Email:Victim {email_id: 'raj_choyal123@yahoo.com'})
CREATE(f:IfscCode:Victim {ifsc_code: '11111111'})
CREATE (p:PinCode:Victim {pincode_num: '111111111111'})
CREATE (m:Mobile:Victim {mobile_num: '9900723780'})

CREATE
(b)-[:HOLDS_AC]->(a)
(b)-[:MAPPED_TO_EMAIL]->(e)
(b)-[:MAPPED_TO_IFSC]->(f)
(b)-[:MAPPED_TO_MOBILE]->(m)
(b)-[:MAPPED_TO_PIN]->(p)

but I am getting following error.
Juxtaposition is currently only supported for quantified path patterns.
In this case, both (b)-[:HOLDS_AC]->(a) and (b)-[:MAPPED_TO_EMAIL]->(e) are simple path patterns.
That is, neither of these is a quantified path pattern. (line 10, column 1 (offset: 390))
"(b)-[:MAPPED_TO_EMAIL]->(e)"

Can someone suggest what is not correct here. I am using 5.19 community version.

2

You are missing commas to separate the patterns in your create. I would just create each with separate create statements.

CREATE (a:AccountHolder:Victim {name: 'Rajesh Patel', dob: '1/1/1070'})
CREATE (b:BankAccount:Victim {account_num: '111111111111'})
CREATE (e:Email:Victim {email_id: 'raj_choyal123@yahoo.com'})
CREATE (f:IfscCode:Victim {ifsc_code: '11111111'})
CREATE (p:PinCode:Victim {pincode_num: '111111111111'})
CREATE (m:Mobile:Victim {mobile_num: '9900723780'})

CREATE (b)-[:HOLDS_AC]->(a)
CREATE (b)-[:MAPPED_TO_EMAIL]->(e)
CREATE (b)-[:MAPPED_TO_IFSC]->(f)
CREATE (b)-[:MAPPED_TO_MOBILE]->(m)
CREATE (b)-[:MAPPED_TO_PIN]->(p)

BTW- you could have separated the patterns with commas as well.

1 Like
3

Thanks Gary, you made it so simple .... I spend almost 4-5 hours on this.....

1 Like