Re: [Neo4j] HA load balancer in Windows Cluster.

2014-07-01 Thread Paul Damian
). That can be something like dns-round-robin if you're only reading, but if you also write to the cluster, you'll have to look into consistent routing (writing to master). See here: http://docs.neo4j.org/chunked/milestone/ha-haproxy.html On Mon, Jun 30, 2014 at 3:48 PM, Paul Damian paulda

[Neo4j] HA load balancer in Windows Cluster.

2014-06-30 Thread Paul Damian
Hi, I have a HA cluster containing 2 Neo4j instances running on VMs that are included in a Windows Failover Cluster. Both VMs run Windows Server 2012 R2. My question is: do I still have to set up a load balancer for the HA Cluster or is the load balancer running on cluster sufficient? Thanks,

Re: [Neo4j] LOAD CSV creates nodes but does not set properties

2014-06-23 Thread Paul Damian
: For me it sounds as if there is a big cross product happening. I.e. many Verticals with the same Id What happens if you do: MATCH (v:Vertical) RETURN v.Id, count(*) Michael Am 18.06.2014 um 15:26 schrieb Paul Damian paulda...@gmail.com javascript:: Hi, I've tried with another

[Neo4j] Cannot run simple query on graph. Any help?

2014-06-23 Thread Paul Damian
Hey guys, I'm quite new to Neo4j and Cypher and I am using it to compare its performance with a SQL database. I've loaded my SQL database into the graph store which now has approx. 13 mil nodes and 13 mil relationships [I have difficulties loading all the relationships]. The nodes are labeled

Re: [Neo4j] LOAD CSV creates nodes but does not set properties

2014-06-23 Thread Paul Damian
I did. Do you have any new ideas on the current topic? luni, 23 iunie 2014, 13:22:38 UTC+3, Michael Hunger a scris: Please start a new thread for this discussion. Am 23.06.2014 um 11:02 schrieb Paul Damian paulda...@gmail.com javascript:: Hey, I'm trying to run a command to find out 10

Re: [Neo4j] LOAD CSV creates nodes but does not set properties

2014-06-18 Thread Paul Damian
: toInt(c.CityId)}) Return count(*) I'm at a conference in Amsterdam this week but perhaps we can do a skype call next week? Michael Sent from mobile device Am 17.06.2014 um 18:48 schrieb Paul Damian paulda...@gmail.com javascript:: Yes, I do. I keep getting Java heap space error now

Re: [Neo4j] LOAD CSV creates nodes but does not set properties

2014-06-18 Thread Paul Damian
18.06.2014 um 11:44 schrieb Paul Damian paulda...@gmail.com javascript:: I cannot run this command. It returns invalid syntax. Only way I could run it was LOAD CSV WITH HEADERS FROM file:/Users/pauld/Documents/LOCATED_IN.csv AS c MATCH (client: Client { Id: toInt(c.Id)}), (city: City { Id

Re: [Neo4j] LOAD CSV creates nodes but does not set properties

2014-06-18 Thread Paul Damian
:/Users/pauld/Documents/LOCATED_IN.csv AS c WITH c LIMIT 100 MATCH (client: Client { Id: toInt(c.Id)}), (city: City { Id: toInt(c.CityId)}) Return count(*) Am 18.06.2014 um 11:44 schrieb Paul Damian paulda...@gmail.com javascript:: I cannot run this command. It returns invalid syntax

Re: [Neo4j] LOAD CSV creates nodes but does not set properties

2014-06-18 Thread Paul Damian
v.Id, count(*) Michael Am 18.06.2014 um 15:26 schrieb Paul Damian paulda...@gmail.com javascript:: Hi, I've tried with another file, which contains ClientdId and VerticalId. The thing is, there are only 7 verticals and 11M clients, so there is an obvious one-to-many relationship

Re: [Neo4j] LOAD CSV creates nodes but does not set properties

2014-06-17 Thread Paul Damian
have a value for city id, do they then have empty columns there still? like user-id,, You probably want to filter these rows? LOAD CSV WITH HEADERS FROM file:/Users/pauld/Documents/LOCATED_IN.csv AS c WHERE coalesce(c.CitiId,) ... Am 17.06.2014 um 11:23 schrieb Paul Damian paulda

Re: [Neo4j] LOAD CSV creates nodes but does not set properties

2014-06-17 Thread Paul Damian
/LOCATED_IN.csv AS c return c limit 10 Am 17.06.2014 um 16:37 schrieb Paul Damian paulda...@gmail.com javascript:: in the file I only have 2 columns, one for client id, which is always not null and CityId, which may be sometimes null. Should I export the records from SQL database leaving

Re: [Neo4j] LOAD CSV creates nodes but does not set properties

2014-06-17 Thread Paul Damian
Yes, I do. I keep getting Java heap space error now. I'm using 100 commit size. marți, 17 iunie 2014, 19:28:05 UTC+3, Michael Hunger a scris: Ok, cool and you have the indexes for both :City(Id) and :Client(Id) ? Michael Am 17.06.2014 um 18:15 schrieb Paul Damian paulda...@gmail.com

[Neo4j] LOAD CSV creates nodes but does not set properties

2014-06-05 Thread Paul Damian
Hi there, I'm experimenting with Neo4j while benchmarking a bunch of NoSQL databases for my graduation paper. I'm using the web interface to populate the database. I've been able to load the smaller tables from my SQL database and LOAD CSV works fine. By small, I mean a few columns (4-5) and

Re: [Neo4j] LOAD CSV creates nodes but does not set properties

2014-06-05 Thread Paul Damian
is imported as one node per row? That's not really a graph structure. On Wed, Jun 4, 2014 at 6:56 PM, Paul Damian paulda...@gmail.com javascript: wrote: Hi there, I'm experimenting with Neo4j while benchmarking a bunch of NoSQL databases for my graduation paper. I'm using the web interface

Re: [Neo4j] LOAD CSV creates nodes but does not set properties

2014-06-05 Thread Paul Damian
, URL: c.URL, Latitude: toFloat(c.Latitude), Longitude: toFloat(c.Longitude), AgencyId: toInt(c.AgencyId), RowStatus: toInt(c.RowStatus)} as data, c as line LIMIT 3 On Thu, Jun 5, 2014 at 10:51 AM, Paul Damian paulda...@gmail.com javascript: wrote: I've tried using the shell and I get

Re: [Neo4j] LOAD CSV creates nodes but does not set properties

2014-06-05 Thread Paul Damian
Also, the properties are not in the same order as in the csv file.. joi, 5 iunie 2014, 12:29:43 UTC+3, Paul Damian a scris: Well, for all properties it sets null values. The data is read well from the file. Is it ok if I have NULL values in the file? Would that be a problem? joi, 5 iunie