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.
