In the second script, there's some syntax to correct off course it should be
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) On Wednesday, 5 March 2014 15:10:05 UTC+1, Tom Zeppenfeldt wrote: > > 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.
