Re: [Neo4j] Hierarchical facets

2014-05-21 Thread Tom Zeppenfeldt
yep, the two individual ones combined take about 12-13 secs . what does the profiling tell you? Met vriendelijke groet / With kind regards Ir. T. Zeppenfeldt van der Waalsstraat 30 6706 JR Wageningen The Netherlands Mobile: +31 6 23 28 78 06 Phone: +31 3 17 84 22 17 E-mail: t.zeppenfe...@oph

Re: [Neo4j] Re: [Neo4j 2.0.3] - Cypher / WHERE NOT syntax with an AND expression

2014-05-21 Thread Michael Azerhad
Ok :) So I Will test it tomorrow ( the man who doesn't understand your meaning/joke ;)) So let's wait .. will surely be an amazing upgrade. Thanks a lot Wes. Le 22 mai 2014 à 03:08, Wes Freeman a écrit : I'll give you a date of tomorrow with confidence +/- 6 months. No idea. :) Last time, t

Re: [Neo4j] Re: [Neo4j 2.0.3] - Cypher / WHERE NOT syntax with an AND expression

2014-05-21 Thread Wes Freeman
I'll give you a date of tomorrow with confidence +/- 6 months. No idea. :) Last time, the RC1 to release time was less than a month, though. I'd love to hear official estimates. Wes On Wed, May 21, 2014 at 7:18 PM, Michael Azerhad wrote: > Oh cool :) > > Do you know when should the 2.1 RELEASE e

Re: [Neo4j] Re: [Neo4j 2.0.3] - Cypher / WHERE NOT syntax with an AND expression

2014-05-21 Thread Michael Azerhad
Oh cool :) Do you know when should the 2.1 RELEASE emerge ? I searched on the Net but in vain. Thanks a lot, Michael On Thursday, May 22, 2014 1:14:21 AM UTC+2, Wes Freeman wrote: > > It looks like it's fixed in 2.1-rc1. > > Wes > > On Wed, May 21, 2014 at 5:48 PM, Michael Azerhad > > > wr

Re: [Neo4j] Re: [Neo4j 2.0.3] - Cypher / WHERE NOT syntax with an AND expression

2014-05-21 Thread Wes Freeman
It looks like it's fixed in 2.1-rc1. Wes On Wed, May 21, 2014 at 5:48 PM, Michael Azerhad wrote: > Thanks to this law: http://en.wikipedia.org/wiki/De_Morgan%27s_laws > > I transform the part: > WHERE NOT(c.name = "Ferrari" AND 1=1) > > to > > WHERE NOT(c.name = "Ferrari") OR NOT(1=1) > > It wou

Re: [Neo4j] Re: assorted Batch Importer questions

2014-05-21 Thread Rich Morin
On Wednesday, May 21, 2014 3:53:42 PM UTC-7, Michael Hunger wrote: > > What was the config you used? (just curious) heap + batch.properties > I have no idea (not a Java user, in general :-); I just used the default settings. If you give me some things to try on a future loading run, I will happil

Re: [Neo4j] Re: assorted Batch Importer questions

2014-05-21 Thread Michael Hunger
What was the config you used? (just curious) heap + batch.properties On Thu, May 22, 2014 at 12:20 AM, Rich Morin wrote: > On Wednesday, May 21, 2014 12:34:15 PM UTC-7, Michael Hunger wrote: >> >> ... Did you do that on Windows or Linux/Mac ? >> Probably more memory or a faster [?] would make

Re: [Neo4j] Re: assorted Batch Importer questions

2014-05-21 Thread Rich Morin
On Wednesday, May 21, 2014 12:34:15 PM UTC-7, Michael Hunger wrote: > > ... Did you do that on Windows or Linux/Mac ? > Probably more memory or a faster [?] would make it faster. > It was run on a Mac Pro ("MacPro3,1", 8-core, 2.8 GHz, 32 GB RAM, SATA disk, OSX 10.7.5). -- You received this me

[Neo4j] Re: [Neo4j 2.0.3] - Cypher / WHERE NOT syntax with an AND expression

2014-05-21 Thread Michael Azerhad
Thanks to this law: http://en.wikipedia.org/wiki/De_Morgan%27s_laws I transform the part: WHERE NOT(c.name = "Ferrari" AND 1=1) to WHERE NOT(c.name = "Ferrari") OR NOT(1=1) It would be good if an AND expression could be evaluated in a NOT expression. On Wednesday, May 21, 2014 11:39:01 P

Re: [Neo4j] Git repository for Neo4J Java REST API ?

2014-05-21 Thread Michael Hunger
Use the JDBC driver or plain http. https://github.com/neo4j-contrib/neo4j-jdbc/tree/2.0 https://github.com/jexp/cypher-http-examples On Wed, May 21, 2014 at 10:51 PM, Darq Moth wrote: > I need Java REST API to query remote server with Cypher. I hope to find > some Java libs that will make wo

[Neo4j] Re: [Neo4j 2.0.3] - Cypher / WHERE NOT syntax with an AND expression

2014-05-21 Thread Michael Azerhad
Even this case: MATCH (c:Car) WHERE NOT(c.name = "Ferrari" AND 1=1) RETURN c.name behaves like: MATCH (c:Car) WHERE NOT(c.name = "Ferrari") AND NOT (1=1) //explaining why 0 rows are returned ! (Indeed NOT (1=1) is never matched) RETURN c.name Why? It seems that an AND expression into

[Neo4j] [Neo4j 2.0.3] - Cypher / WHERE NOT syntax with an AND expression

2014-05-21 Thread Michael Azerhad
Hi everyone, My case is very simple. Let's assume three Car nodes: Car(name: "Ferrari") Car(name: "Porsche") Car(name: "Aston Martin") And this request: MATCH (c:Car) RETURN c.name This of course well returns the three names. Now I want to execute this simple query using a WHERE NOT: MATCH

Re: [Neo4j] Git repository for Neo4J Java REST API ?

2014-05-21 Thread Darq Moth
I need Java REST API to query remote server with Cypher. I hope to find some Java libs that will make working with queries like: MATCH p = (n {id: '" + nodeId + "'})-[*]-(m) RETURN nodes(p) as nodes easier then just making a series of HTTP request and parsing JSON. Please advise. On Thursday, Ma

Re: [Neo4j] Git repository for Neo4J Java REST API ?

2014-05-21 Thread Michael Hunger
What is it that you actually want to achieve? Michael On Wed, May 21, 2014 at 10:21 PM, Darq Moth wrote: > Hello, > The only info I could find at Neo4J site about Java REST API is this: > http://docs.neo4j.org/chunked/stable/server-java-rest-client-example.html > From this info it is not clear

Re: [Neo4j] Git repository for Neo4J Java REST API ?

2014-05-21 Thread Peter Neubauer
Hi, most of the basic endpoints are in https://github.com/neo4j/neo4j/blob/master/community/server/src/main/java/org/neo4j/server/rest/web/RestfulGraphDatabase.java, the rest in the surrounding classes. HTH /peter G: neubauer.peter S: peter.neubauer P: +46 704 106975 L: http://www.linkedin

[Neo4j] Git repository for Neo4J Java REST API ?

2014-05-21 Thread Darq Moth
Hello, The only info I could find at Neo4J site about Java REST API is this: http://docs.neo4j.org/chunked/stable/server-java-rest-client-example.html >From this info it is not clear at all if Java REST API provides any more or less high-level functions to parse results that Cypher query returns

Re: [Neo4j] Re: assorted Batch Importer questions

2014-05-21 Thread Michael Hunger
Sounds not too bad. Did you do that on Windows or Linux/Mac ? Probably more memory or a faster would make it faster. Do you have the csv-files to share somewhere? Thanks a lot Michael On Wed, May 21, 2014 at 2:39 PM, Rich Morin wrote: > FYI, I appear to have done a successful import of the

Re: [Neo4j] py2neo working in read-only mode

2014-05-21 Thread Александр Богданов
Thank you very much. All is working now. Fun fact. In last two things i tried to use i encountered with bugs. Previous was in Cork (plugin for Bottle python web-framework). There was bug with threads and SQLite instances. Maybe my destiny is to be a tester? LOL Thanx again... среда, 21 мая 201

Re: [Neo4j] Hierarchical facets

2014-05-21 Thread Michael Hunger
That's why I suggested UNION. So the two individual queries take 14s? Still way too long. On Wed, May 21, 2014 at 3:40 PM, Tom Zeppenfeldt wrote: > I have some problems starting the shell from my Mac Terminal (it's giving > me a out of mem error) , but form the webadmin powerconsole. Can't find

Re: [Neo4j] Multithreading in Transaction Java API

2014-05-21 Thread Christopher Scott
Your most likely I/O bound instead of CPU bound. If you haven't tried already, since you are only doing reads you might be able to omit the tx.success() call inside the transaction. Another thing you can try is doing more inside of one transaction (batching), as well as trying the BatchInserte

Re: [Neo4j] Survey: which language do you use? (python, java, etc)

2014-05-21 Thread Nigel Small
There are language drivers available for most major programming languages (mine is the Python one): http://www.neo4j.org/develop/drivers In terms of choosing a language, Java wins if you are looking for raw performance - although that is becoming less of an issue as Cypher improves. It can also b

Re: [Neo4j] Hierarchical facets

2014-05-21 Thread Tom Zeppenfeldt
yeah.. found that out too .. profiled things are already in groups. Met vriendelijke groet / With kind regards Ir. T. Zeppenfeldt van der Waalsstraat 30 6706 JR Wageningen The Netherlands Mobile: +31 6 23 28 78 06 Phone: +31 3 17 84 22 17 E-mail: t.zeppenfe...@ophileon.com Web: www.ophileon

Re: [Neo4j] Hierarchical facets

2014-05-21 Thread Michael Hunger
Prefix your query with "profile " Sent from mobile device Am 21.05.2014 um 15:40 schrieb Tom Zeppenfeldt : > I have some problems starting the shell from my Mac Terminal (it's giving me > a out of mem error) , but form the webadmin powerconsole. Can't find any > documentation either on how to

Re: [Neo4j] py2neo working in read-only mode

2014-05-21 Thread Nigel Small
Michael's guess is correct, there is a bug in the *Session.execute* method: https://github.com/nigelsmall/py2neo/blob/feature/bindable/py2neo/cypher.py#L153 Here, the call should be made to *commit* instead of *execute*. I suggest that you use the longer form of *append* and *commit* until this

Re: [Neo4j] Survey: which language do you use? (python, java, etc)

2014-05-21 Thread Alex Frieden
In general for neo4j I would stick to java. Embedded API is written in it, tons of web UIs written in it(RoR, grails, SDN), and the jdbc driver is very friendly for java (not sure if there is a python equivalent) On Wed, May 21, 2014 at 10:12 AM, wrote: > I'm new to the community and to graph

[Neo4j] Survey: which language do you use? (python, java, etc)

2014-05-21 Thread chrismichaels84
I'm new to the community and to graph databases, but I am finding it all very useful. I was wondering, however, what most people use to actually access the databases? This is NOT a which "language is best" question, and I am not talking about query language (cypher, gremlin, oSQL). I mean java,

Re: [Neo4j] Hierarchical facets

2014-05-21 Thread Tom Zeppenfeldt
I have some problems starting the shell from my Mac Terminal (it's giving me a out of mem error) , but form the webadmin powerconsole. Can't find any documentation either on how to set shell to have me return profile. neo4j-sh (?)$ export termname="Eurovoc" *Your first Query* neo4j-sh (?)$ matc

Re: [Neo4j] py2neo working in read-only mode

2014-05-21 Thread Александр Богданов
I'm sorry, but I cant understand what logs you mean? It's web application. In neo4j folder i can't see any requests log. Where to find it? o-o Thank you. среда, 21 мая 2014 г., 16:22:31 UTC+4 пользователь Michael Hunger написал: > > Not sure how py2neo does it internally with these statements, bu

Re: [Neo4j] Hierarchical facets

2014-05-21 Thread Michael Hunger
Can you perhaps do the profiling in the shell? The profile there is more readable than the JSON? how long does this one take? match (j:jurt)-[:HAS_TERM]->()-[:BT*0..]->(t:term)-[:BT]->(t2:term {name:{termname}}) return t.name, count(distinct j) as count order by count desc limit 10 and this one

[Neo4j] Re: Problem with addRelationship using REST API from JAVA

2014-05-21 Thread Sotiris Beis
Τη Παρασκευή, 16 Μαΐου 2014 12:55:15 μ.μ. UTC+3, ο χρήστης Sotiris Beis έγραψε: > > Hi, > I have the following code snippet > https://gist.github.com/sarovios/3552c424afacecf680dc where I try to > create a simple graph. Unlike the example > here

[Neo4j] Re: assorted Batch Importer questions

2014-05-21 Thread Rich Morin
FYI, I appear to have done a successful import of the YAGO2s data set: Importing 76887797 Nodes took 709 seconds Importing 128395059 Relationships took 2904 seconds Total import time: 3816 seconds real 63m 41.190s user 24m 59.220s sys 9m 34.858s -- You re

[Neo4j] Query not returning for 20 million nodes with relationship and loads of properties....

2014-05-21 Thread vaibhav nirkhe
Hi All, I have 3 type of nodes joined with relationship and each node have heavy set of properties , the total number of nodes are around 20 million with node store size around 250 MB and property store of size 8GB , however my queries at this volume are not performing at all , followin

Re: [Neo4j] py2neo working in read-only mode

2014-05-21 Thread Michael Hunger
Not sure how py2neo does it internally with these statements, but I think you still have to commit your query. According to the docs it commits immediately, but perhaps there is a bug, so that the node goes away after tx-timeout? Could you produce an http log of the http requests between your pyt

Re: [Neo4j] py2neo working in read-only mode

2014-05-21 Thread Александр Богданов
Dump! All is really stopped without correct working of this... QQ понедельник, 19 мая 2014 г., 21:48:43 UTC+4 пользователь Александр Богданов написал: > > Sure it's local. > > look what happen: > > 1. graph before query: > http://i.gyazo.com/85dfbc3152117cd50334085b9b9254b5.png > 2. running exa

[Neo4j] Hierarchical facets

2014-05-21 Thread Tom Zeppenfeldt
Hi, after publishing this graphgist http://gist.neo4j.org/?05d92f567adbe971afc5 , Michael suggested to change the pattern and providing a profile. This is the result: The query is { "query" : "match (j:jurt)-[:HAS_TERM]->()-[:BT*0..]->(t:term)-[:BT*0..1]->(t2:term {name:{termname}}) return

Re: [Neo4j] which is Better : relationship vs node

2014-05-21 Thread Navrattan Yadav
thanks Michael . After creating Model i will share On Wed, May 21, 2014 at 2:29 PM, Michael Hunger < michael.hun...@neotechnology.com> wrote: > Perhaps you can start by modelling that in a GraphGist with Cypher Queries > for the use-cases. And then we can discuss it on these concrete examples? >

Re: [Neo4j] which is Better : relationship vs node

2014-05-21 Thread Michael Hunger
Perhaps you can start by modelling that in a GraphGist with Cypher Queries for the use-cases. And then we can discuss it on these concrete examples? See: http://www.neo4j.org/learn/graphgist And gist.neo4j.org -> examples list on the right On Wed, May 21, 2014 at 10:53 AM, Navrattan Yadav < navr

Re: [Neo4j] which is Better : relationship vs node

2014-05-21 Thread Navrattan Yadav
>From data i want to calculate : 1. which location is most visited by user. 2. which path is most visited by users 3. also need track a user : path or location visited by him. 4. Also need to track how muck time a user spent on a location On Wed, May 21, 2014 at 2:19 PM, Michael Hunger < mich

Re: [Neo4j] Cypher query with partial matching on property string.

2014-05-21 Thread Michael Hunger
Use fulltext-search, see http://jexp.de/blog/2014/03/full-text-indexing-fts-in-neo4j-2-0/ On Wed, May 21, 2014 at 12:54 AM, Alx wrote: > The title of the topic says it all. How can I use a cypher to retrieve all > the nodes with a word contained inside a property? For example, I have a > node P

Re: [Neo4j] which is Better : relationship vs node

2014-05-21 Thread Michael Hunger
Depends on your use-case, what do you want to do with the data? If you just want to store the fact that the user was there a relationship is good enough. If the actual visit is a really important concept in your domain that also other things are linked to and which has its own identity then a node

[Neo4j] which is Better : relationship vs node

2014-05-21 Thread Navrattan Yadav
hi . i am using Neo4j 2.0.3 version. i am working on a DB where we need to track user path based on some fixed location. like which location is most visited. so what i am doing : 1. Each user has unique node. 2. Each location has unique node. when user traverse a location then which is better