Could be, thanks for pointing it out. Will try.
Michael Am 07.03.2014 um 02:24 schrieb Tom Zeppenfeldt <[email protected]>: > 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]>: > >> Michael, I'm running on a machine with >> >> 2GB Ram 40GB SSD DiskUbuntu 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 [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]. >>> 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/d/optout. -- 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.
