Re: [Neo4j] CSV importer chokes on large files creating relations

2014-06-26 Thread Eric Olson
ndex by default and you have to force > cypher to use the other index too with "USING INDEX grp:Group(name) > > > On Fri, Jun 6, 2014 at 9:46 PM, Eric Olson > wrote: > >> Yes, I also tried USING PERIODIC COMMIT with 1 and 5 values. >> >> Yes, a

[Neo4j] Re: Variable in OPTIONAL MATCH loses scope when paired with USING INDEX

2014-06-26 Thread Eric Olson
FYI - This is using Neo4j 2.1.2 personal enterprise On Thursday, June 26, 2014 9:32:10 AM UTC-6, Eric Olson wrote: > > I have run into a unique situation (bug?). Here is my query that does what > it is supposed to: > > MATCH >(:Author {name: {author} })-[:WROTE_BOOK]-

[Neo4j] Variable in OPTIONAL MATCH loses scope when paired with USING INDEX

2014-06-26 Thread Eric Olson
I have run into a unique situation (bug?). Here is my query that does what it is supposed to: MATCH (:Author {name: {author} })-[:WROTE_BOOK]->(b:Book {name_min: {book} })-[:HAS_CHAPTER]->(c:Chapter {chapter: {chapter} })-[:HAS_TEXT]->(t:Text), (lang:Language {language: {lang} }), (vers

Re: [Neo4j] LOAD CSV - Wanting to set property name, not value

2014-06-25 Thread Eric Olson
t; add one foreach for each potential value. > > Michael > > Am 24.06.2014 um 18:43 schrieb Eric Olson >: > > Using > > USING PERIODIC COMMIT 5 > LOAD CSV WITH HEADERS FROM 'file:/mcpdata/8_grp-aco.csv' AS line > MATCH (group:Group { name: line.group }

[Neo4j] LOAD CSV - Wanting to set property name, not value

2014-06-24 Thread Eric Olson
Using USING PERIODIC COMMIT 5 LOAD CSV WITH HEADERS FROM 'file:/mcpdata/8_grp-aco.csv' AS line MATCH (group:Group { name: line.group }), (aco:ACO { name: line.aco }) CREATE (group)-[:AXO { line.axo: true }]->(aco) fails because as you can see on the last line I am trying to set a property NA

Re: [Neo4j] Using Cypher CSV import tool where data has commas

2014-06-12 Thread Eric Olson
Lol. True :) I will do it the right way next time. Thanks for the lesson :) On Thursday, June 12, 2014 2:34:09 PM UTC-6, Wes Freeman wrote: > > That will work, until you have a tab in that arbitrary text. :) Then > you'll need quotes again. > > Wes > > On Thu, Jun 12, 2

Re: [Neo4j] Using Cypher CSV import tool where data has commas

2014-06-12 Thread Eric Olson
break, double-quote, and/or commas *should* be >quoted. (If they are not, the file will likely be impossible to process >correctly). > > > id,another_data,text > "1234","data","This can have commas, so this part never gets imported!" &g

[Neo4j] Using Cypher CSV import tool where data has commas

2014-06-12 Thread Eric Olson
I am trying to import a large amount of data using Cypher's new LOAD CSV tool. The problem is that one of my properties will contain some arbitrary text which contains a lot of commas in itself. A basic picture of my data would look like: { "id": 1234, "another_data": "data", "text": "Thi

Re: [Neo4j] Adding a node in Running Neo4j HA cluster.

2014-06-11 Thread Eric Olson
Are you saying that we can just swap out the configuration files while the instance is running and it will pick up on the changes? On Thursday, December 12, 2013 4:36:48 AM UTC-7, Peter Neubauer wrote: > > This is not true (anymore). > > Since we switched to Paxos instead of Zookeeper, you should

Re: [Neo4j] How do HA read work?

2014-06-09 Thread Eric Olson
harding_with_haproxy > > Another recommendation is to direct writes to master and reads to slaves, > and we have this: > http://docs.neo4j.org/chunked/stable/ha-haproxy.html#_optimizing_for_reads_and_writes > > > Hope that helps? > > - Lasse > > > > > &g

[Neo4j] How do HA read work?

2014-06-09 Thread Eric Olson
I am playing with a personal, enterprise license of v2.1.1. I have set up a HA cluster (3 instances) on my local machine. The cluster is up and running as verified through the webadmin console and writes to master and slaves are populating through out the cluster as expected. Basically, it all w

Re: [Neo4j] CSV importer chokes on large files creating relations

2014-06-09 Thread Eric Olson
e neo4j-shell of your import of a > tiny variant? > > e.g. your 10k file? > > I could imagine it only uses one index by default and you have to force > cypher to use the other index too with "USING INDEX grp:Group(name) > > > On Fri, Jun 6, 2014 at 9:46 PM, Eric

Re: [Neo4j] CSV importer chokes on large files creating relations

2014-06-06 Thread Eric Olson
simply CREATEs nodes? On Friday, June 6, 2014 12:10:54 PM UTC-6, Michael Hunger wrote: > > How did it fail? > > Did you try USING PERIODIC COMMIT 1 ? > > Do you have an index for : :User(name) and :Group(name) ? > > > On Fri, Jun 6, 2014 at 12:34 AM, Eric Olson >

[Neo4j] CSV importer chokes on large files creating relations

2014-06-06 Thread Eric Olson
I have read some other topics on this and am still coming up short on a satisfying solution. I am: - Populating my DB using the new CSV import query in Cypher - Using the Neo4j shell - Including the "USING PERIODIC COMMIT" statement I have: - Successfully imported a 10,000 line fil