Hi,
im new to Neo4j, Currently im tryig to make dating site as POC.
I have 4gb of Input file which is look like bellow format. This contains
viewerId(male/female), viewedId which is list of id's they have viewed.
Based on this histry file, I need to give recommendation when any user
comes to online.
*Input file:*
*viewerId viewedId *
*12345 123456,23456,987653 *
*23456 23456,123456,234567 *
*34567 234567,765678,987653 *
:
For this task, i tried the following way,
*USING PERIODIC COMMIT 10000*
*LOAD CSV WITH HEADERS FROM "file:/home/hadoopuser/Neo-input " AS row*
*FIELDTERMINATOR '\t'*
*WITH row, split(row.viewedId, ",") AS viewedIds*
*UNWIND viewedIds AS viewedId*
*MERGE (p2:Persons2 {viewerId: row.viewerId})*
*MERGE (c2:Companies2 {viewedId: viewedId})MERGE (p2)-[:Friends]->(c2)*
*MERGE (c2)-[:Sees]->(p2);*
and My Cypher query to get result is,
*MATCH (p2:Persons2)-[r*1..3]->(c2: Companies2)*
*RETURN p2,r, COLLECT(DISTINCT c2) as friends *
To complete this task, it will take 3 days.
My system config:
Ubuntu -14.04
RAM -24GB
To reduce time, I search and get one idea in internet like Batch importer
from the following link,
https://github.com/jexp/batch-import
In that link, they have node.csv, rels.csv files, they imported into
Neo4j. Im not getting any idea about how they are creating node.csv and
rels.csv files which scripts ther are using and all. Can anyone give me
sample script to make node.csv and rels.csv files for my data? Or can you
say any suggestion to make import and retrive data fastly?
Thanks in Advance.
--
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.
