Re: [Neo4j] export-graphml

2015-03-09 Thread Koen Kleingeld
hi michael, thanks ! The following worked for me : export-graphml -o "c:/neo4jdata/test.graphml" -r so indeed no url format, forward slashed and the -r option was required also reg koen 2015-03-09 19:09 GMT+01:00 Michael Hunger : > I think the difference is that import-graphml can read from

Re: [Neo4j] Unable to upgrade 2.1.6 database to 2.2.0-RC1

2015-03-09 Thread bill
This looks like the relevant portion of the log: 2015-03-09 21:19:18.514+ INFO [o.n.s.e.EnterpriseNeoServer]: Setting startup timeout to: 12ms based on 12 2015-03-09 21:19:18.741+ INFO [o.n.k.i.s.StoreMigrationTool]: Starting upgrade of database store files 2015-03-09 21:19:18.

[Neo4j] Re: 1 Billion nodes DB: slow performance when connecting

2015-03-09 Thread Lorenzo Speranzoni (@inserpio)
I use SSD on a Debian Server with every sort configuration still at its default value. Index creation was fast: 524ms. Count is very slow and it doesn't use any index: Planner COST EagerAggregation | +AllNodesScan +--+---+++-

[Neo4j] Re: 1 Billion nodes DB: slow performance when connecting

2015-03-09 Thread Lorenzo Speranzoni (@inserpio)
I'm observing it's become faster now: I'm wondering if it performed some sort of computation the very first time I tryed to access the db? Il giorno martedì 10 marzo 2015 00:55:41 UTC+1, Michael Hunger ha scritto: > > Oh and the counting doesn't use an index (right now, it might use the > kern

[Neo4j] Re: 1 Billion nodes DB: slow performance when connecting

2015-03-09 Thread Michael Hunger
Oh and the counting doesn't use an index (right now, it might use the kernel statistics at some point). On Tuesday, March 10, 2015 at 12:41:12 AM UTC+1, Lorenzo Speranzoni (@inserpio) wrote: > > Hi All, > > I'm testing performances on a 1 Billion nodes database. > > To create nodes I used Michae

[Neo4j] Re: 1 Billion nodes DB: slow performance when connecting

2015-03-09 Thread Michael Hunger
Can you try to get a thread dump for the connecting? Also did you run this on an SSD or HDD? SSD should be much faster! I took only 40s for me with 12 cores. Maxing out an SSD raid at 1G/s. The index will take a while, that's true And the cypher statement will pull through 1bn nodes into memory

[Neo4j] 1 Billion nodes DB: slow performance when connecting

2015-03-09 Thread Lorenzo Speranzoni (@inserpio)
Hi All, I'm testing performances on a 1 Billion nodes database. To create nodes I used Michael Hunger's code here: https://gist.github.com/jexp/0ff850ab2ce41c9ca5e6 The import when really well: it took 5m 22s 235ms But when I try to connect to the just created database via shell, I took reall

Re: [Neo4j] Unable to upgrade 2.1.6 database to 2.2.0-RC1

2015-03-09 Thread Michael Hunger
yes, you're right could you check the graph.db/messages.log file? Thanks so much. Michael > Am 09.03.2015 um 22:26 schrieb b...@levelstory.com: > > I'm trying to test out the new Release Candidate of 2.2 but it won't upgrade > my database from 2.1.6. I've made sure to shut down the 2.1.6 dat

[Neo4j] Unable to upgrade 2.1.6 database to 2.2.0-RC1

2015-03-09 Thread bill
I'm trying to test out the new Release Candidate of 2.2 but it won't upgrade my database from 2.1.6. I've made sure to shut down the 2.1.6 database cleanly: dev:~/Downloads/neo4j-enterprise-2.1.6/bin$ sudo ./neo4j stop Stopping Neo4j Server [3940]... done And made sure to allow for store u

Re: [Neo4j] export-graphml

2015-03-09 Thread Michael Hunger
I think the difference is that import-graphml can read from an URL but as you can't write to an URL the export only supports normal path syntax. ie. "c:\neo4jdata\test.graphml" Michael > Am 09.03.2015 um 16:46 schrieb koen : > > Hi, when i perform an import-graphml it works fine but with expor

[Neo4j] export-graphml

2015-03-09 Thread koen
Hi, when i perform an import-graphml it works fine but with export-graphml i keep getting an error on the filename (w7) - neo4j-sh (?)$ import-graphml -i "file:///c:/neo4jdata/test.graphml" - ==> GraphML-Import file file:///c:/neo4jdata/test.graphml rel-type RELATED_TO batch-size 4 us

[Neo4j] Intersection cypher query is not working

2015-03-09 Thread Shijo c j
Hi all, I have just started using Neo4j.Now I am working with Cypher queries.Here I am deeply twisted with one intersection query. Here I have Two labels called SourceTwittername And DestTwittername. SourceTwittername consist of following nodes(source1,source2,source3,source4,source5) and Dest

Re: [Neo4j] specify data type

2015-03-09 Thread Michael Hunger
Currently you can only use the conversion functions like toString, toFloat, toInt Michael > Am 09.03.2015 um 08:50 schrieb FERHAT Ilyes : > > I wonder if it's possible to specify the type of data while inserting in the > database( for example: integer, long, string, ... ) using CYPHER queries,

Re: [Neo4j] How to use same relationship object for multiple relations

2015-03-09 Thread Michael Hunger
It was just a typo in the case statement which you could have found yourself if you read the error message correctly. MATCH (genre:Genre)-[:HAS_CHANNEL]->(channel:Channel)-[:HAS_PROGRAM]->(program:Program)-[:HAS_SUBSCRIBER_JOINED]->(subscriber:Subscriber), (totalViewTime:TotalViewTime), (subscr

[Neo4j] specify data type

2015-03-09 Thread FERHAT Ilyes
I wonder if it's possible to specify the type of data while inserting in the database( for example: integer, long, string, ... ) using CYPHER queries, just like the relational database?! Thank you. -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To