Re: Hi

[Aileen Agricola]

Hi Grant,

I'm forwarding your question to our google group.  Our community can assist you with your questions.

best,

Aileen Agricola

Aileen Agricola

Web Program Manager | Neo Technology 

aileen....@neotechnology.com | 206.437.2524

Join us at GraphConnect 2014 SF! graphconnect.com
As a friend of Neo4j, use discount code *KOMPIS* for $100 off registration

On Tue, Oct 28, 2014 at 6:24 AM, Grant Wilkinson <Gra...@sahomeloans.com> wrote:

Hi

 

I’m busy with some investigation into NEO4J to as a possible tool for our analytics department, and although the documentation and various talks do praise Neo4j, I am really struggling to get some very basic things working.

 

Here are a few of the issues that I’ve encountered, and I’d like to know if there is a preferred tool to interface or perhaps I should use a different version of Neo4J?

 

1.       When using running a query, the query does not get submitted, after repeated submissions of the query (In the web browser interface), eventually the query gets accepted and results are returned.

2.       When creating relationships between two node types, the query runs for an extended period, and then I receive the “Unknown” error. Initially I got frustrated with this, and so I changed my tatic. And so creating the relationships during import from csv.. please see the next error.

3.       As mentioned before on importing some UserDetails, and at the same time adding reltionships, I get the following error..

Query:

USING PERIODIC COMMIT LOAD CSV WITH HEADERS FROM "file:///C:/Grant/Work/Neo4J/Import Data/UserDetails.csv" AS csvLine

CREATE (p:SAHLUser {   ADUserSKey: toInt(csvLine.ADUserSKey) ,

                                                                                                ADUserName: toInt(csvLine.ADUserName) ,

                                                                                                UsersName: toInt(csvLine.UsersName),

                                                                                                Branch: csvLine.Branch,

                                                                                                Division: csvLine.Division,

                                                                                                Department: csvLine.Department

                                                                                }

                                )

WITH p, csvLine

MATCH (off:SAHLOffer {ADUserSKey: toInt(csvLine.ADUserSKey)})

MERGE (p)-[:ActedOn]->(off);

 

Error.

 

I’d really like to try out your software, but these types of errors are making it unusable, if there is a better way of dealing with this, or perhaps if the 30 day enterprise version will help please let me know.

 

Regards

Grant

 

 

 

 

Grant Wilkinson Database Developer
T: +27 31 571 3015 | F: +27 (0) 31 562 0362 | C: +27 73 616 8789 E: Gra...@sahomeloans.com

This email and all contents are subject to the following disclaimer:http://www.sahomeloans.com/sahl/sahomeloansdisclaimer.pdf

[Michael Hunger]

Hi Grant,

please always share the queries that you tried, otherwise it is impossible to guess what the reason could be.

Can you also state something about your data model, data size and cardinality distribution?

for 1. -> how does that materialize? Are the queries not running or do you see no output? I had some UX issues when the browser was zoomed in (90% or smaller)

for 2. -> please share that query

for 3. -> what machine are you running this on ? RAM, OS, etc? Did you change any configuration ? It would help us a lot if you could share your graph.db/messages.log with me.

Could you split your query into two runs ?

create two indices/constraints first (please change the constraint to an index if the ADUserSKey is not unique in :SAHLUser

create index on :SAHLOffer(ADUserSKey);

create constraint on (p:SAHLUser) assert p.ADUserSKey is unique;

first

USING PERIODIC COMMIT 

LOAD CSV WITH HEADERS FROM "file:///C:/Grant/Work/Neo4J/Import Data/UserDetails.csv" AS csvLine

CREATE (p:SAHLUser { ADUserSKey: toInt(csvLine.ADUserSKey) ,

 ADUserName: toInt(csvLine.ADUserName) ,

 UsersName: toInt(csvLine.UsersName),

 Branch: csvLine.Branch,

 Division: csvLine.Division,

 Department: csvLine.Department})

second

USING PERIODIC COMMIT 

LOAD CSV WITH HEADERS FROM "file:///C:/Grant/Work/Neo4J/Import Data/UserDetails.csv" AS csvLine

MATCH (p:SAHLUser { ADUserSKey: toInt(csvLine.ADUserSKey)})

MATCH (off:SAHLOffer {ADUserSKey: toInt(csvLine.ADUserSKey)})

MERGE (p)-[:ActedOn]->(off);

Thanks a lot.

Michael

--
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 neo4j+un...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.