Re: [Neo4j] LOAD CSV takes over an hour

2014-03-05 Thread Michael Hunger
I just tested your file on MacOS with these settings and got 6:30 for the 2m rows EXTRA_JVM_ARGUMENTS=-Xmx6G -Xms6G -Xmn1G on windows you have to add the memory from the mmio settings in neo4j.properties to the heap cat conf/neo4j.properties # Default values for the low-level graph engine

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

2014-03-05 Thread Michael Hunger
Yes, why not? I assume that is a 1:1 relationship. Whatever m,q,k mean? you should probably use more descriptive names for those :) Michael Am 05.03.2014 um 11:35 schrieb Sukaant Chaudhary sukaant.chaudh...@gmail.com: Hi Michael, I'll change the relation the way you suggested. Here in this

Re: [Neo4j] Neo4j MusicBrainz example database

2014-03-05 Thread Michael Hunger
Hi Nicola, it could be that the database was created with Neo4j 2.0-M06 and there were changes in RC1 in terms of the label indexes. Thanks for the heads up, I'll have a look and update it to 2.0.1 Michael Am 04.03.2014 um 16:52 schrieb Nicola Sampietri nicola.sampie...@gmail.com: Hi, i

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

2014-03-05 Thread Sukaant Chaudhary
Thanks Michael -Sukaant Chaudhary [image: linkedinbutton]http://in.linkedin.com/pub/sukaant-chaudhary/33/ba8/479/ On Wed, Mar 5, 2014 at 4:31 PM, Michael Hunger michael.hun...@neopersistence.com wrote: Yes, why not? I assume that is a 1:1 relationship. Whatever m,q,k mean? you should

Re: [Neo4j] Shortest Path and Timeout configuration

2014-03-05 Thread Michael Hunger
But you should already get paths back? Can you describe your graph shape? Remember cycles don't work well there. Could you update your version to 1.9.6 or 2.0.1 ? I think you could use a custom PathExpander that just doesn't return anything anymore or throws an exception when a certain time

Re: [Neo4j] LOAD CSV takes over an hour

2014-03-05 Thread Michael Hunger
Oh and btw. I would LOVE to see a blog post from you about what you're working on! Thanks so much Michael Am 05.03.2014 um 12:00 schrieb Michael Hunger michael.hun...@neopersistence.com: I just tested your file on MacOS with these settings and got 6:30 for the 2m rows

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

2014-03-05 Thread Tom Zeppenfeldt
Michiel, sorry I overlooked this series of questions On Tuesday, 4 March 2014 21:45:30 UTC+1, Michael Hunger wrote: The nodes that are returned, do they actually have the :Term label? yes they do .. tested with match (t:Term) return t.name, labels(t) and match (t:Term

[Neo4j] Neo4j 1.9.4 WI dashboard shows drastically invalid counts

2014-03-05 Thread Illya
Dear all, After, as it seems, a clear restart of the Neo4j server (running before smoothly for several months) *the web interface's dashboard suddenly started to show absolutely wrong counts*, i.e.: Before restart: nodes - ~600 (!), relationships - ~50k, etc. After restart: nodes - ~122k

[Neo4j] Re: Neo4j 1.9.4 WI dashboard shows drastically invalid counts

2014-03-05 Thread Illya
Using Scientific Linux 6, with Oracle JDK 1.7.0_25. -- 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. For more options, visit

Re: [Neo4j] Neo4j 1.9.4 WI dashboard shows drastically invalid counts

2014-03-05 Thread Peter Neubauer
Did you do a lot of deletes in your app? The numbers show the highest ID in use, which is no equal to the number of IDs in use. /peter G: neubauer.peter S: peter.neubauer P: +46 704 106975 L: http://www.linkedin.com/in/neubauer T: @peterneubauer Neo4j 2.0.0

[Neo4j] CrudRepository.exists and inheritance don't work well together

2014-03-05 Thread Grégoire Colbert
Hi, I have an abstract class OrganisationNode containing a @GraphId id field. I have several concrete classes extending OrganisationNode, for example InstitutionNode or CommunityNode. None of them have a @GraphId field. If I put another @GraphId id field on InstitutionNode, I get the

Re: [Neo4j] LOAD CSV takes over an hour

2014-03-05 Thread Aram Chung
Wow this is great! I'll definitely try what you did. Please expect questions along the way. And a write-up is coming; I was thinking I'd do that as soon as I get some relationships in, but now I should probably make a post about LOAD CSV. I'll post a link when I do. Thanks! Aram On

Re: [Neo4j] Neo4j 1.9.4 WI dashboard shows drastically invalid counts

2014-03-05 Thread Illya
Well, that's the point - no massive deletes of nodes at all. Total number of nodes *never* went over ~650, and for relationships - over ~60k. There was once a removal of ~5k of relationships though, but this can not explain the jump of 50k - 150k. -- You received this message because you are

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

2014-03-05 Thread Tom Zeppenfeldt
In the second script, there's some syntax to correct off course it should be USING PERIODIC COMMIT LOAD CSV FROM http://www.ophileon.com/neo4j/eurovoc_broader.csv; AS csvLine MATCH (t:Term { id: toInt(csvLine[0])}),(bt:Term { id: toInt(csvLine[1])}) CREATE (t)-[:BT]-(bt) On Wednesday, 5

[Neo4j] Re: CrudRepository.exists and inheritance don't work well together

2014-03-05 Thread Grégoire Colbert
Hi, I'm trying to override the boolean exists(Long) function in my CrudRepositories interfaces, and I think I have found an inconsistency in Cypher about the return clause. The method I want to add to CommunityRepository is : @Override @Query(value = match (n:Community) where

[Neo4j] Running Neo4j query from command.

2014-03-05 Thread Alx
I am running a neo4j query from a .cql file using the following command: ./bin/neo4j-shell -file query.cql result.txt However the results insided result.txt are wrapped with '-' and '|' marks that makes it hard to post-process. Is it possible to have the neo4j shell not put these marks?

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

2014-03-05 Thread Chris Leishman
Hey Nikolay, So this is an interesting query: the thing that stands out the most to me is that this query isn't doing anything with relationships - it's not taking advantage of the graph. So all that's left for Neo4j to do is to begrudgingly walk through every single Book and put them in order

[Neo4j] HA backup don't load data

2014-03-05 Thread Juliano Baggio di Sopra
After an instance make backup from other, it start but don't load data. I'm tried manual backup, and the error continues. The console.log show only backup debug info. The neo4j.0.0.log show error: Mar 05, 2014 3:30:50 PM com.sun.jersey.spi.container.ContainerResponse

[Neo4j] Running Neo4j with multiple process

2014-03-05 Thread Reihane Boghrati
Hi, How can I load my database with multiple processes? This is my init function: static GraphDatabaseService graphDb; private static final String DB_PATH = C:/Users/Reihane/Documents/Neo4j/default.graphdb; public boolean init() throws DBException { if (graphDb == null) graphDb = new

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

2014-03-05 Thread Craig Taverner
Perhaps as a concrete example of what Chris is describing here, I can comment further. The original example had three properties to order on, isbn, titel, pubDate. The text 'and so on' implies more, but let's assume there are not too many more. If there are indeed a limited number of predictable

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

2014-03-05 Thread Michael Hunger
Hi Tom, I did exactly what you did (on MacOS) and it worked out of the box, could you perhaps retry on an empty db? What OS are you using? LOAD CSV FROM http://www.ophileon.com/neo4j/eurovoc_terms.csv; AS csvLine CREATE (t:Term { id: toInt(csvLine[0]), name: csvLine[1]});

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

2014-03-05 Thread Michael Hunger
Great answer, I want to second that. Esp. when sending in the last place in the chain where you want to continue. New syntax would be this and I would also add the limit directly to the path-expression (unfortunately not possible as parameter MATCH p=(n)-[:next*20]-(x) WHERE id(n) = {prev_id}

Re: [Neo4j] Running Neo4j with multiple process

2014-03-05 Thread Michael Hunger
Only one active process at a time can access the storage files. What do you want to do? Michael Am 06.03.2014 um 01:03 schrieb Reihane Boghrati r.boghr...@gmail.com: Hi, How can I load my database with multiple processes? This is my init function: static GraphDatabaseService

[Neo4j] Returning literal maps works in shell but not in rest with cypher

2014-03-05 Thread Ben
https://github.com/neo4j/neo4j/issues/1789 Is there any update to this issue? When it might be fixed? Thanks! -- 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

Re: [Neo4j] Running Neo4j with multiple process

2014-03-05 Thread Reihane Boghrati
I want to load my database with 10,000 users nodes with 4 process. Is there any possibility to do that? For example can I specify a different db_path for each process and run them? On Wednesday, March 5, 2014 8:14:14 PM UTC-8, Michael Hunger wrote: Only one active process at a time can access

[Neo4j] neo4j_2.1.0.M01_all.deb Hash Sum mismatch

2014-03-05 Thread Marshall Bishop
Getting the following with apt-get upgrade on Ubuntu 12.04_LTS: Failed to fetch http://debian.neo4j.org/repo/testing/neo4j_2.1.0.M01_all.deb Hash Sum mismatch I saw that this was something the devs had to fix in a previous thread with a different version upgrade. Thanks, Marshall -- You

Re: [Neo4j] Returning literal maps works in shell but not in rest with cypher

2014-03-05 Thread Michael Hunger
Yep as you noted fixed in 2.0.1 Sent from mobile device Am 05.03.2014 um 21:27 schrieb Ben bfona...@ngs.org: https://github.com/neo4j/neo4j/issues/1789 Is there any update to this issue? When it might be fixed? Thanks! -- You received this message because you are subscribed to the

Re: [Neo4j] Running Neo4j with multiple process

2014-03-05 Thread Michael Hunger
Why? You can load them in less than a second Or use multiple threads Sent from mobile device Am 06.03.2014 um 05:41 schrieb Reihane Boghrati r.boghr...@gmail.com: I want to load my database with 10,000 users nodes with 4 process. Is there any possibility to do that? For example can I

Re: [Neo4j] Running Neo4j with multiple process

2014-03-05 Thread Reihane Boghrati
I use multiple threads (200 threads). I have 10,000 users, 4 friends per user and 10 resource per users. The relations are like: (users) -[firnedships]-(users) (resources)-[createdFor]-(users) (users)-[create]-(resources) First I create all users nodes, then I create friendship between two

Re: [Neo4j] CrudRepository.exists and inheritance don't work well together

2014-03-05 Thread Michael Hunger
Great question. You're not expected to override exists. It should actually just work. I would appreciate a JIRA issue with the content of this email. Not sure I understand it all, so a test-project with a failing unit-test would be awesome. Thanks a lot Michael I think most sense would make

Re: [Neo4j] Running Neo4j with multiple process

2014-03-05 Thread Michael Hunger
If you import them all at once you should have larger transaction sizes, anything from 1000 to 5 elements per transaction. See this for an explanation: http://jexp.de/blog/2013/05/on-importing-data-in-neo4j-blog-series/ Michael Am 06.03.2014 um 07:18 schrieb Reihane Boghrati

Re: [Neo4j] Running Neo4j query from command.

2014-03-05 Thread Michael Hunger
What do you actually want to achieve ? You can send your cypher query to the http endpoint and get the json back if that helps you. Otherwise if you want to have other outputs, perhaps you are interested in my shell-tools that allow a lot different import and export formats

Re: [Neo4j] Passport.js with Neo4j

2014-03-05 Thread Michael Hunger
Doesn't passport separate storage from auth? So you would use whatever node.js driver you want to use with Neo4j to implement the serialization. According to http://passportjs.org/guide/configure - Sessions at least The serialization and deserialization logic is supplied by the application,