I created a new Ubuntu VM on which I did it, against a running server. Agree with you that it's weird. There's still a thingy that I have to test. Before running it on the problematic server, I dropped a unique constraint on the Term.id. And created a non-unique index on Term.id .Perhaps it makes a difference.
On Friday, 7 March 2014 01:44:00 UTC+1, Michael Hunger wrote: > > Hi Tom, > > Did you retry it? With my steps? > Somehow this is really weird > > Btw. I used the neo4j-shell directly, not against a running Neo4j server. > Had to copy opencsv.jar from system/lib to lib/ to make it work :) > > Michael > > Am 07.03.2014 um 00:02 schrieb Tom Zeppenfeldt > <[email protected]<javascript:> > >: > > 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 <[email protected]>: >> >> 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 <[email protected]>: >> >> 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 <[email protected]>: >> >> 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. >> <http://googlegroups.com/>com<http://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 [email protected]. >> 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 [email protected]. >> 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 [email protected] <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 [email protected]. For more options, visit https://groups.google.com/d/optout.
