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.
