Re: [Neo4j] LOAD CSV takes over an hour

2014-04-10 Thread david fauth
Aram, I have some cycles and can possibly help. you can reach me at dsfauth at gmail dot com df On Monday, April 7, 2014 5:03:20 PM UTC-4, Aram Chung wrote: Rodger: Thanks! I agree, Opencorporates.com is lovely. My project isn't really about corporations though; it just happened that

Re: [Neo4j] LOAD CSV takes over an hour

2014-06-18 Thread david fauth
Run the Create Constraint commands then attempt your LOAD CSV command. On Wednesday, June 18, 2014 5:13:42 AM UTC-4, Pavan Kumar wrote: Hi, So My cypher will be like -- USING PERIODIC COMMIT 1000 LOAD CSV WITH HEADERS FROM

Re: [Neo4j] Neo4j server not starting after replacing graph.db with a new one (with same name)

2014-08-18 Thread david fauth
Maria, Mohana, You can download the Twitter-Heroku example dataset for neo4j 2.1.3 here: http://neo4j-examples.s3.amazonaws.com/twitter-connections/neo4j_213/graph.db.zip Once you unzip the file, copy the graph.db directory into your data directory. The Neo4j server should start then. Dave

[Neo4j] Re: Music Brainz Data Set Query not returning

2014-08-20 Thread david fauth
The second query is reading every node and relationship in the database. You should specify an artist in the match statement as well as use the indexing to quickly return results. Look at this post: http://neo4j.com/blog/musicbrainz-in-neo4j-part-1/?_ga=1.249198849.72284.1406858145 On

[Neo4j] Re: Memory Configuration

2014-08-27 Thread david fauth
Chris, You want to set these to the same value. wrapper.java.initmemory=8192 wrapper.java.maxmemory=8192 I would also change the neo4j.properties settings to something like: neo4j.properties: neostore.nodestore.db.mapped_memory=500M neostore.relationshipstore.db.mapped_memory=1G

Re: [Neo4j] ACTUAL regexp Matching?!

2014-09-22 Thread david fauth
this works in the console: match n where n.name =~ '^[A-Z ]+\\. [A-Z ]+' return n; On Monday, September 22, 2014 6:08:23 PM UTC-4, Michael Hunger wrote: You probably have to double escape. try: RETURN A Z. A Z =~ '^[A-Z ]+\\. [A-Z ]+' and in regexps you don't have to escape spaces.

[Neo4j] Re: Neo4j complex cypher query slow performace

2014-10-10 Thread david fauth
What indexes do you have created? On Friday, October 10, 2014 2:07:51 PM UTC-4, Nikita Sushkov wrote: Hi. I have a query which looks like this: MATCH (comp:Company {id: 7})-[:HAS_SPACE]-(s:Space)-[:HAS_BOARD]-(b), (col)-[:HAS_COLUMN]-(b)-[:HAS_LANE]-(lane) OPTIONAL MATCH

[Neo4j] Re: How to log query statement on server, is it possible?

2014-12-29 Thread david fauth
In 2.1.6, you can log the fullRequest and fullResponse. Note that this may have a performance impact: To enable the HTTP logging: 1) Update the neo4j-server properties file: #* # HTTP logging configuration

[Neo4j] Re: Example Data Sets crashing version 2.1.6

2014-12-29 Thread david fauth
Ramki, I've downloaded the Hubway Data Challenge and placed the contents into the graph.db directory. You will want to uncomment the following line in your conf/neo4j.properties file allow_store_upgrade=true Once you make that change and save the file, you can start the Neo4j server and it

[Neo4j] Re: How To Set the db path of neo4j to Amazon S3

2015-01-13 Thread david fauth
I'm curious as to why you would want to host your Neo4j database in Amazon S3. One solution would be to look at a product like ExpanDrive ( http://www.expandrive.com/docs/map-network-drive/connecting-to-amazon-s3) which lets you map an S3 bucket as a drive letter on Windows or as a Network

[Neo4j] Re: Import data from Hadoop to Neo4j

2015-01-07 Thread david fauth
Lobna, There are a few ways of doing this. The easiest way is to create a set of CSV files for the nodes and relationships. You can use Talend to do this. I will often write Pig jobs to output the data that I want. In Neo4j 2.2, the new Neo4j-import capability makes loading large data sets

[Neo4j] Re: Shortest path

2015-05-06 Thread david fauth
Something like this should work: MATCH p=shortestPath(a)--(b)--(c) WHERE a.name='Alice' AND b.name='Bob' AND c.name='Daniel' RETURN extract(n IN nodes(p)| n.name) AS extracted On Wednesday, May 6, 2015 at 11:29:47 AM UTC-4, FERHAT Ilyes wrote: Hi, I'm trying to find the shortest path between

[Neo4j] Re: Batch weirdness with current py2neo

2015-08-17 Thread David Fauth
Alan, I'll send a note to Nigel Small and have him take a look. Dave On Monday, August 17, 2015 at 1:50:19 PM UTC-4, AlanR wrote: Hi, Twice I've tried to convert to py2neo 2.x. Both times I ran into this problem. The first time I had to revert the 2.0 changes and put out the release

[Neo4j] Re: Neo4J(Client) is running out of memory

2015-07-13 Thread david fauth
Peter, Have you set your JVM settings in conf/neo4j-wrapper.conf? You can set the JVM settings around line 46-47 of that file. You can set them to either 2048 or 4096 depending on the amount of memory in your machine. Also, set both of the initmemory and maxmemory values to the same settings.

[Neo4j] Re: Can not restart Neo4j after crashed

2016-02-17 Thread David Fauth
How long did you let 2.2.3 try and recover? It has to recover the database successfully before it can be loaded into a new database. On Tuesday, February 16, 2016 at 7:51:26 AM UTC-5, 宋鹏 wrote: > > Hello, wish to get some help here... > > I deployed a neo4j server of version 2.2.3 several months