Dear Experts,
I have about 88K nodes.
Label: Person
match n
return labels(n), n
limit 100;
| ["Person"] |
Node[97]{personid:98,email:"[email protected]",name:"",enron:1,domainid:4058,msgrec_to:85,msgrec_tot:85}
|
| ["Person"] |
Node[98]{personid:99,email:"[email protected]",name:"",enron:1,domainid:4058,msgrec_to:240,msgrec_tot:338,msgrec_cc:98}
|
| ["Person"] |
Node[99]{personid:100,email:"[email protected]",name:"",enron:1,domainid:4058,msgrec_to:139,msgrec_tot:141,msgrec_cc:2}
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------+
100 rows
----
I have a CSV file of the relationships.
head /home/notes/enron/mailgraph4.csv
"senderid","recipientid","total_to","total_cc","total_bcc","total_emails"
"1","2","39",\N,\N,"39"
"3","2","11",\N,\N,"11"
"4","5","208","9",\N,"217"
"4","6","1","51",\N,"52"
"4","7",\N,"4",\N,"4"
"4","110",\N,"1",\N,"1"
"4","374",\N,"2",\N,"2"
"4","375","10","12",\N,"22"
"4","399",\N,"11",\N,"11"
----
I use LOAD CSV to create the relationships,
begin transaction
USING PERIODIC COMMIT
LOAD CSV WITH HEADERS FROM "file:///home/notes/enron/mailgraph4.csv" AS
csvLine
MATCH ( from:Person { personid: toInt(csvLine.senderid )}), ( to:Person {
personid: toInt(csvLine.recipientid )})
CREATE ( from ) -[ :AGG_EMAILS ]-> ( to )
;
+-------------------+
| No data returned. |
+-------------------+
Relationships created: 99
42477 ms
commit
Transaction committed
----
and I'm getting odd results.
start r=relationship(*) return r;
...
| :AGG_EMAILS[193]{} |
| :AGG_EMAILS[194]{} |
| :AGG_EMAILS[195]{} |
| :AGG_EMAILS[196]{} |
| :AGG_EMAILS[197]{} |
| :AGG_EMAILS[198]{} |
+--------------------+
99 rows
649 ms
----
There is a number appended to the name of the relationship which is not
supposed to be there.
What is incorrect here please?
Thanks a lot!
--
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.
