Re: [Neo4j] Need help in modification of the query

2014-03-04 Thread Michael Hunger
And what doesn't work? It might make sense to create a LOCATION_PERMANENT rel-type instead. to speed things up. Michael Am 04.03.2014 um 13:33 schrieb Sukaant Chaudhary : > Hi, > In the following query I want to add the highlighted conditions with bold, > Please help me how to add: > > START

[Neo4j] Re: Need help in modification of the query

2014-03-04 Thread Sukaant Chaudhary
Anyone please help me how to get this. -Sukaant Chaudhary [image: linkedinbutton] On Tue, Mar 4, 2014 at 6:03 PM, Sukaant Chaudhary < sukaant.chaudh...@gmail.com> wrote: > Hi, > In the following query I want to add the highlighted cond

Re: [Neo4j] LOAD CSV takes over an hour

2014-03-04 Thread Michael Hunger
Oh and if you use neo4j-shell without server you have to set the heap in bin\Neo4jShell.bat in EXTRA_JVM_ARGUMENTS="-Xmx4G -Xms4G -Xmn1G" and call bin\Neo4jShell -conf conf\neo4j.properties -path data\graph.db Am 05.03.2014 um 08:29 schrieb Michael Hunger : > Yep, > > it would be also inter

Re: [Neo4j] LOAD CSV takes over an hour

2014-03-04 Thread Michael Hunger
Also if you're not yet creating rels (i.e. read your writes you should also be able to up the periodic commit to 50k) Michael Am 05.03.2014 um 08:29 schrieb Michael Hunger : > Yep, > > it would be also interesting how you ran this? With neo4j-shell? Against a > running server? > Did you conf

Re: [Neo4j] LOAD CSV takes over an hour

2014-03-04 Thread Michael Hunger
Yep, it would be also interesting how you ran this? With neo4j-shell? Against a running server? Did you configure any RAM or memory mapping setting in neo4j.properties? Check out this blog post for some hints on memory config: http://blog.bruggen.com/2014/02/some-neo4j-import-tweaks-what-and-wh

[Neo4j] Re: Recommended GC and mapped settings for a large sized database

2014-03-04 Thread David Fox
What GC method are you using? We use about a 30gb heap and had a decent amount of issues with ConcMarkSweep combined with a high amount of requests. A few people at Neo4j recommended G1 and it helped us a lot. Not sure how your app works, but with ours it usually takes G1 a little time to adapt

Re: [Neo4j] no results when not providing label ? 2.1.0-M01

2014-03-04 Thread Tom Zeppenfeldt
No idea. on this particular server, which is a sandbox and has nothing else except the java and neo4j it's happening consistently. in a DM I can provide you the url of the instance, if that helps. best, Tom Met vriendelijke groet / With kind regards Ir. T. Zeppenfeldt van der Waalsstraat 30

Re: [Neo4j] Recommended GC and mapped settings for a large sized database

2014-03-04 Thread Virat Gohil
Hi Michael, Thank you very much for the quick and concise reply. We are using Ubuntu Linux 13.04. 1. I was not aware that we can get a server extension that can talk in our domain APIs, could you point/recommend any that we can extend/customize to our needs. 2. I believe I we have configured the

Re: [Neo4j] Recommended GC and mapped settings for a large sized database

2014-03-04 Thread Michael Hunger
# What is your OS? #1 you should probably not use SDN over REST if your application is performance critical, look into a embedded deployment or better server extension that talks your domain API #2 you would want to configure the memory mapping to fit your store files on disk #3 you would probab

Re: [Neo4j] Exception: org.neo4j.graphdb.NotInTransactionException when creating multiple relationships

2014-03-04 Thread Michael Hunger
You have to wrap your operation in a transaction: http://docs.neo4j.org/chunked/stable/tutorials-java-embedded-hello-world.html#_wrap_operations_in_a_transaction Am 04.03.2014 um 21:32 schrieb Ruby : > So I have a program, whereby I create all the nodes and add relationships > from and to them.

Re: [Neo4j] preload test database with database on filesystem

2014-03-04 Thread Michael Hunger
You can insert data with the usual APIs but right now there is no way to move an existing store into memory. You could also use a RAMDISK for a similar effect. Michael Am 04.03.2014 um 22:07 schrieb Javad Karabi : > is it possible to load an impermanent test database with the data from a > fi

[Neo4j] preload test database with database on filesystem

2014-03-04 Thread Javad Karabi
is it possible to load an impermanent test database with the data from a filesystem? -- 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+unsubscr...@googlegroups.com

[Neo4j] Recommended GC and mapped settings for a large sized database

2014-03-04 Thread Virat Gohil
Hi, Before I start, I would like to commend the efforts of the fantastic team for making a beautiful and intuitive Graph database. I am new to using Neo4j and have been using it for about 2 months now and so far I love it! I have a few queries with respect to tuning Neo4j for performance, as we

[Neo4j] Exception: org.neo4j.graphdb.NotInTransactionException when creating multiple relationships

2014-03-04 Thread Ruby
So I have a program, whereby I create all the nodes and add relationships from and to them. When creating these nodes they are stored in nodes_created, for me to then use in relationship creation. for(Map.Entry entry: company_counts_backward.entrySet()){ String[] node_names

Re: [Neo4j] no results when not providing label ? 2.1.0-M01

2014-03-04 Thread Michael Hunger
The nodes that are returned, do they actually have the :Term label? According to the profile it filters out the nodes on the name comparison. Not on the label actually. Perhaps you can share the CSV and the load-csv script that you ran? Michael Am 04.03.2014 um 21:33 schrieb Tom Zeppenfeldt :

Re: [Neo4j] no results when not providing label ? 2.1.0-M01

2014-03-04 Thread Tom Zeppenfeldt
micheal, just a quick reply because i'm on the road: - it was a brand new clean install - nodes loaded with new LOAD FROM CSV procedure - no indexes added when i add profile=true. i get this response { "columns" : [ "p" ], "data" : [ ], "plan" : { "args" : { "returnItemNames" :

[Neo4j] [neo4j-community edition windows] Running separate versions e.g 2.0.1 & 2.1.0m01

2014-03-04 Thread olive22
Hi all, I have downloaded installed both 2.0.1 & 2.1.0M01 Windows 64bit installers, and installed them in separate directories. While the launcher allows me to specifiy which database I want to run, the settings tab does not allow me to change the "Server Configuration" & "Java VM Options" paths

[Neo4j] Does ORDER BY scale to large amount of data compared to RDBMS?

2014-03-04 Thread Nikolay Artamonov
Hi guys! ) My graph consists nodes labeled as :Book. In application I have to present table of books in paged manner and with sorting capabilities by various properties, for example: MATCH (b:Book) RETURN b ORDER BY *b.isbn*SKIP {offset} LIMIT { booksPerPage} MATCH (b:Book) RETURN b ORDER B

[Neo4j] REST logs with java-rest-binding

2014-03-04 Thread Kyle Williams
Hi I'm trying to log REST requests using the java-rest-binding. I'm using the "2.0-labels-and-indexes" branch. I added wrapper.java.additional=-Dorg.neo4j.rest.logging_filter=true to conf/neo4j-wrapper.conf and set logging level to FINEST in conf/lo

Re: [Neo4j] LOAD CSV takes over an hour

2014-03-04 Thread Mark Needham
Hi Aram, * Do you have any other information of the spec of the machine you're running this on? e.g. how much RAM etc * Have you tried upping the value to PERIODIC COMMIT? Perhaps try it out with a smaller subset of the data to measure the impact - try it with values of 1,000 / 10,000 perhaps. * I

[Neo4j] LOAD CSV takes over an hour

2014-03-04 Thread Aram Chung
Hi, I was asked to post this here by Mark Needham (@markhneedham) who thought my query took longer than it should. I'm trying to see how graph databases could be used in investigative journalism: I was loading in New York State's Active Corporations: Beginning 1800 data from https://data.ny.g

[Neo4j] Neo4j MusicBrainz example database

2014-03-04 Thread Nicola Sampietri
Hi, i downloaded the MusicBrainz database from http://example-data.neo4j.org/files/musicbrainz_neo_20.tar.bz2. I'm using this neo4j database for a "Big Data" demo. I have some problem with this simple cypher query : MATCH (n:Area) return n; The result is : +---+ | n | +---+ +---+ 0 row 1016 m

Re: [Neo4j] API change proposal on Node

2014-03-04 Thread AL Wad
> > Thank you Chris, > So every set should be like if (node.hasProperty("propLabel") && node.getProperty("propLabel").equals("propValueToCheck") ) node.setProperty("propLabel", "whatever"); Verbous but no try/catch. I'll take that although checking for null is more java Thank you

[Neo4j] Shortest Path and Timeout configuration

2014-03-04 Thread Guru
I am using Java API in an embedded graph (version 1.9.4) and using the following code to get the ShortestPath - GraphAlgoFactory.shortestPath(expander, 15) where expander is a expander with specific relationship types. In rare cases, the graph (which is about 28 G on a JVM sized to 10G) just s

Re: [Neo4j] API change proposal on Node

2014-03-04 Thread Chris Vest
You can test for the existence of a property on a Node or Relationship with the hasProperty(key) method. It is defined by the PropertyContainer interface. -- Chris Vest System Engineer, Neo Technology [ skype: mr.chrisvest, twitter: chvest ] On 04 Mar 2014, at 12:50, AL Wad wrote: > Hello, >

[Neo4j] Aggregation: collect() from relationship properties with order

2014-03-04 Thread Raúl Kripalani
Hello, My graph is quite simple and the relevant parts look like this: u:User ---[BELONGS_TO]---> (*..1) h:Country, properties: code | |-[RECEIVED]-> (1..*) nx:Notification, properties: text,ordinal All nx:Notification nodes have a property 'ordinal' which is a

[Neo4j] API change proposal on Node

2014-03-04 Thread AL Wad
Hello, I'm new to Neo && presume the post fits better here than on SO && feeling courageous. I wrote an app to update my graph via the REST API (using org.neo4j.rest.graphdb.RestGraphDatabase). My use case is getting nodes I previously created to set a property which is absent (or not). 1/

[Neo4j] Need help in modification of the query

2014-03-04 Thread Sukaant Chaudhary
Hi, In the following query I want to add the highlighted conditions with bold, Please help me how to add: START n=node(2) MATCH (n)-[:FOLLOWED_BY*..5]->(m) WITH DISTINCT m MATCH (m)-[:PUBLISHED_UNDER*..5]->(q)<-[:PUBLISHED_BY*..5]-(k)*, (q)-[l:LOCATION]->(t) //Add This* WHERE (q.eventSta

[Neo4j] How to return random records in Neo4j using Cypher?

2014-03-04 Thread Rio Eduardo
I have query like this: $query = "MATCH (U:User) RETURN U ORDER BY RAND() LIMIT 100"; But when I run this, this shows errors. It says: Caught Exception: Unable to execute query [400]: Headers: Array ( [Content-Type] => application/json; charset=UTF-8; stream=true [Access-Control-Allow-Orig

Re: [Neo4j] How to query for relationship by startNode and endNode

2014-03-04 Thread Modi Tamam
Sorry, didn't get it. Can you please share a link to a detailed explanation or example, I just couldn't find one. On Tue, Mar 4, 2014 at 12:54 PM, Michael Hunger < michael.hun...@neopersistence.com> wrote: > If you have the rel from a match or path and want to access either of > these nodes > >

Re: [Neo4j] How to query for relationship by startNode and endNode

2014-03-04 Thread Michael Hunger
If you have the rel from a match or path and want to access either of these nodes Sent from mobile device Am 04.03.2014 um 11:15 schrieb Modi Tamam : > Thank's. > In what use case, should I use the end/startNode methods? > > > On Tue, Mar 4, 2014 at 12:12 PM, Michael Hunger > wrote: >>> mat

Re: [Neo4j] How to query for relationship by startNode and endNode

2014-03-04 Thread Modi Tamam
Thank's. In what use case, should I use the end/startNode methods? On Tue, Mar 4, 2014 at 12:12 PM, Michael Hunger < michael.hun...@neopersistence.com> wrote: > match (a)-[r]->(b) where id(a)=4768 AND id(b)=4767 return count(r) > > > Am 04.03.2014 um 11:00 schrieb Modi Tamam : > > I need to veri

Re: [Neo4j] How to query for relationship by startNode and endNode

2014-03-04 Thread Michael Hunger
> match (a)-[r]->(b) where id(a)=4768 AND id(b)=4767 return count(r) Am 04.03.2014 um 11:00 schrieb Modi Tamam : > I need to verify the existance of a relationship between two nodes (I have > their both Id's) > > In the documentation that can be found here, in the relationships section, > ther

[Neo4j] How to query for relationship by startNode and endNode

2014-03-04 Thread Modi Tamam
I need to verify the existance of a relationship between two nodes (I have their both Id's) In the documentation that can be found here, in the relationships section, there is a startNode and endNode functions. I wanted to write a query that will look somethi

Re: [Neo4j] How To Solve 500 internal server error

2014-03-04 Thread Sukaant Chaudhary
Thanks Michael, it worked fine for me. -Sukaant Chaudhary [image: linkedinbutton] On Tue, Mar 4, 2014 at 2:16 PM, Michael Hunger < michael.hun...@neopersistence.com> wrote: > use single quotes within the cypher statement or a parameter

Re: [Neo4j] How To Solve 500 internal server error

2014-03-04 Thread Michael Hunger
use single quotes within the cypher statement or a parameter for "PERMANENT" Am 04.03.2014 um 08:37 schrieb Sukaant Chaudhary : > Hi, > I'm using following query and parameter: > { > "query": "START m=node({unode}) OPTIONAL MATCH > (m)-[r:FOLLOWED_BY|CREATED_BY|FOLLOW_PENDING]->(n)-[l:LOCAT

Re: [Neo4j] no results when not providing label ? 2.1.0-M01

2014-03-04 Thread Michael Hunger
Tom: did you by chance upgrade from 2.0M06 ? Then you have to do a manual update procedure. http://blog.neo4j.org/2013/11/neo4j-200-rc1-final-preparations.html Did you create any indexes? Can you add a ?profile=true to the endpoint to show the profile Michael Am 04.03.2014 um 02:54 schrieb Tom