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
On Tue, Oct 28, 2014 at 5:59 PM, Aileen Agricola <
[email protected]> wrote:
> 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
> [email protected] | 206.437.2524
>
> *Join us at GraphConnect 2014 SF! graphconnect.com
> <http://graphconnect.com/>*
> *As a friend of Neo4j, use discount code *KOMPIS
> <https://graphconnect2014sf.eventbrite.com/?discount=KOMPIS>* for $100 off
> registration*
>
>
> On Tue, Oct 28, 2014 at 6:24 AM, Grant Wilkinson <[email protected]>
> 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:* [email protected]
>> This email and all contents are subject to the following disclaimer:
>> http://www.sahomeloans.com/sahl/sahomeloansdisclaimer.pdf
>>
>
> --
> 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.
>
--
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.
