Michael, I'm running on a machine with 2GB Ram 40GB SSD Disk Ubuntu 13.10 x64
On Wednesday, 5 March 2014 16:22:01 UTC+1, Michael Hunger wrote: > > 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]}); > +-------------------+ > | No data returned. | > +-------------------+ > Nodes created: 12907 > Properties set: 25814 > Labels added: 12907 > 5407 ms > neo4j-sh (?)$ create index on :Term(id); > +-------------------+ > | No data returned. | > +-------------------+ > Indexes added: 1 > 311 ms > neo4j-sh (?)$ schema > Indexes > ON :Term(id) ONLINE > > No constraints > > neo4j-sh (?)$ USING PERIODIC COMMIT 1000 > > 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); > +-------------------+ > | No data returned. | > +-------------------+ > Relationships created: 7775 > > neo4j-sh (?)$ match (t:Term {name:{term}})<-[:BT]-(p:Term) return p; > ParameterNotFoundException: Expected a parameter named term > neo4j-sh (?)$ export term=document > neo4j-sh (?)$ match (t:Term {name:{term}})<-[:BT]-(p:Term) return p; > +------------------------------------------------------------+ > | p | > +------------------------------------------------------------+ > | Node[6599]{id:320247,name:"Staatscourant"} | > | Node[6600]{id:320248,name:"grijze literatuur"} | > | Node[6607]{id:320255,name:"microreproductie"} | > | Node[6615]{id:320263,name:"jaarboek"} | > | Node[6617]{id:320265,name:"monografie"} | > | Node[6618]{id:320266,name:"perscommuniqu_"} | > | Node[6626]{id:320274,name:"correspondentie"} | > | Node[6628]{id:320276,name:"woordenboek"} | > | Node[6634]{id:320282,name:"toespraak"} | > | Node[6636]{id:320284,name:"audiovisueel document"} | > | Node[6637]{id:320285,name:"officieel document"} | > | Node[6639]{id:320287,name:"parlementsstukken"} | > | Node[6647]{id:320295,name:"grafische illustratie"} | > | Node[6649]{id:320297,name:"incunabel"} | > | Node[6651]{id:320299,name:"manifest"} | > | Node[6652]{id:320300,name:"manuscript"} | > | Node[6653]{id:320301,name:"plattegrond"} | > | Node[6656]{id:320304,name:"officieel stempel"} | > | Node[6682]{id:320330,name:"citaat"} | > | Node[6683]{id:320331,name:"nota van toelichting"} | > | Node[6684]{id:320332,name:"elektronisch document"} | > | Node[6685]{id:320333,name:"reisgids"} | > | Node[6687]{id:320335,name:"biografie"} | > | Node[6693]{id:320341,name:"catalogus"} | > | Node[6694]{id:320342,name:"conferentiehandelingen"} | > | Node[6700]{id:320348,name:"handboek"} | > | Node[6704]{id:320352,name:"pauselijk besluit"} | > | Node[6709]{id:320357,name:"offici�le verklaring"} | > | Node[6710]{id:320358,name:"vergelijkende studie"} | > | Node[6711]{id:320359,name:"casestudy"} | > | Node[6713]{id:320361,name:"voorgeschiedenis"} | > | Node[6715]{id:320363,name:"atlas"} | > | Node[6717]{id:320365,name:"meertalig woordenboek"} | > | Node[6719]{id:320367,name:"woordenboek van afkortingen"} | > | Node[6721]{id:320369,name:"encyclopedie"} | > | Node[6722]{id:320370,name:"thesaurus"} | > | Node[6723]{id:320371,name:"tijdschrift"} | > | Node[6725]{id:320373,name:"krant"} | > | Node[6728]{id:320376,name:"documentair hulpmiddel"} | > | Node[6731]{id:320379,name:"proefschrift"} | > | Node[6733]{id:320381,name:"bibliografie"} | > | Node[6745]{id:320393,name:"publicatie"} | > | Node[6749]{id:320397,name:"verslag"} | > | Node[6751]{id:320399,name:"verslag over de werkzaamheden"} | > | Node[6753]{id:320401,name:"onderzoeksverslag"} | > | Node[6756]{id:320404,name:"Publicatieblad EU"} | > | Node[6760]{id:320408,name:"zaakregister"} | > | Node[6761]{id:320409,name:"formulier"} | > | Node[11264]{id:324917,name:"wetenschappelijke expertise"} | > | Node[12589]{id:442333,name:"EU-publicatie"} | > +------------------------------------------------------------+ > 50 rows > 601 ms > neo4j-sh (?)$ match (t:Term {name:{term}})<-[:BT]-(p) return p; > +------------------------------------------------------------+ > | p | > +------------------------------------------------------------+ > | Node[6599]{id:320247,name:"Staatscourant"} | > | Node[6600]{id:320248,name:"grijze literatuur"} | > | Node[6607]{id:320255,name:"microreproductie"} | > | Node[6615]{id:320263,name:"jaarboek"} | > | Node[6617]{id:320265,name:"monografie"} | > | Node[6618]{id:320266,name:"perscommuniqu_"} | > | Node[6626]{id:320274,name:"correspondentie"} | > | Node[6628]{id:320276,name:"woordenboek"} | > | Node[6634]{id:320282,name:"toespraak"} | > | Node[6636]{id:320284,name:"audiovisueel document"} | > | Node[6637]{id:320285,name:"officieel document"} | > | Node[6639]{id:320287,name:"parlementsstukken"} | > | Node[6647]{id:320295,name:"grafische illustratie"} | > | Node[6649]{id:320297,name:"incunabel"} | > | Node[6651]{id:320299,name:"manifest"} | > | Node[6652]{id:320300,name:"manuscript"} | > | Node[6653]{id:320301,name:"plattegrond"} | > | Node[6656]{id:320304,name:"officieel stempel"} | > | Node[6682]{id:320330,name:"citaat"} | > | Node[6683]{id:320331,name:"nota van toelichting"} | > | Node[6684]{id:320332,name:"elektronisch document"} | > | Node[6685]{id:320333,name:"reisgids"} | > | Node[6687]{id:320335,name:"biografie"} | > | Node[6693]{id:320341,name:"catalogus"} | > | Node[6694]{id:320342,name:"conferentiehandelingen"} | > | Node[6700]{id:320348,name:"handboek"} | > | Node[6704]{id:320352,name:"pauselijk besluit"} | > | Node[6709]{id:320357,name:"offici�le verklaring"} | > | Node[6710]{id:320358,name:"vergelijkende studie"} | > | Node[6711]{id:320359,name:"casestudy"} | > | Node[6713]{id:320361,name:"voorgeschiedenis"} | > | Node[6715]{id:320363,name:"atlas"} | > | Node[6717]{id:320365,name:"meertalig woordenboek"} | > | Node[6719]{id:320367,name:"woordenboek van afkortingen"} | > | Node[6721]{id:320369,name:"encyclopedie"} | > | Node[6722]{id:320370,name:"thesaurus"} | > | Node[6723]{id:320371,name:"tijdschrift"} | > | Node[6725]{id:320373,name:"krant"} | > | Node[6728]{id:320376,name:"documentair hulpmiddel"} | > | Node[6731]{id:320379,name:"proefschrift"} | > | Node[6733]{id:320381,name:"bibliografie"} | > | Node[6745]{id:320393,name:"publicatie"} | > | Node[6749]{id:320397,name:"verslag"} | > | Node[6751]{id:320399,name:"verslag over de werkzaamheden"} | > | Node[6753]{id:320401,name:"onderzoeksverslag"} | > | Node[6756]{id:320404,name:"Publicatieblad EU"} | > | Node[6760]{id:320408,name:"zaakregister"} | > | Node[6761]{id:320409,name:"formulier"} | > | Node[11264]{id:324917,name:"wetenschappelijke expertise"} | > | Node[12589]{id:442333,name:"EU-publicatie"} | > +------------------------------------------------------------+ > 50 rows > 331 ms > > Am 05.03.2014 um 15:10 schrieb Tom Zeppenfeldt > <tomzepp...@gmail.com<javascript:> > >: > > 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 {name:'document'})<-[:BT]-(p:Term) return p.name, > labels(p) > > > 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? > > USING PERIODIC COMMIT > > LOAD CSV FROM "http://www.ophileon.com/neo4j/eurovoc_terms.csv"; AS > csvLine > > CREATE (t:Term { id: toInt(csvLine[0]), name: csvLine[1]}) > > and > > 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) > > at this moment, the db only contains the :Term nodes. > > > Michael > > > Am 04.03.2014 um 21:33 schrieb Tom Zeppenfeldt <tomzepp...@gmail.com>: > > 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" : [ "p" ], > "_rows" : 0, > "_db_hits" : 0, > "symKeys" : [ "p", "t", " UNNAMED28" ] > }, > "dbHits" : 0, > "name" : "ColumnFilter", > "children" : [ { > "args" : { > "_rows" : 0, > "_db_hits" : 9240, > "pred" : "Property(t,name(1)) == {term}" > }, > "dbHits" : 9240, > "name" : "Filter", > "children" : [ { > "args" : { > "start" : { > "identifiers" : [ "t" ], > "producer" : "NodeByLabel", > "label" : "Term" > }, > "trail" : "(t)<-[ UNNAMED28:BT WHERE true AND true]-(p)", > "_rows" : 9240, > "_db_hits" : 9240 > }, > "dbHits" : 9240, > "name" : "TraversalMatcher", > "children" : [ ], > "rows" : 9240 > } ], > "rows" : 0 > } ], > "rows" : 0 > } > } > > On Tuesday, 4 March 2014 02:26:45 UTC-6, Michael Hunger wrote: > 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 Zeppenfeldt <tomzepp...@gmail.com>: > > This query to http://mydomain.com:7474/db/data/cypher > > { > "query" : "match (t:Term {name:{term}})<-[:BT]-(p:Term) return p", > "params" : { > "term" : "document" > } > } > > returns the expected nodes > > however this query, just leaving out the specification of the label of p: > > { > "query" : "match (t:Term {name:{term}})<-[:BT]-(p) return p", > "params" : { > "term" : "document" > } > } > > returns nothing, which I didn't expect. Did I miss something? > > -- > 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+un...@googlegroups.com. > For more options, visit https://groups.google.com/groups/opt_out. > > > > -- > 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+un...@googlegroups.com. > For more options, visit https://groups.google.com/groups/opt_out. > > > > -- > 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+un...@googlegroups.com <javascript:>. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- 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 https://groups.google.com/groups/opt_out.
