I have some problems starting the shell from my Mac Terminal (it's giving me a out of mem error) , but form the webadmin powerconsole. Can't find any documentation either on how to set shell to have me return profile.
neo4j-sh (?)$ export termname="Eurovoc" *Your first Query* neo4j-sh (?)$ match (j:jurt)-[:HAS_TERM]->()-[:BT*0..]->(t:term)-[:BT]->(t2:term {name:{termname}}) return t.name, count(distinct j) as count order by count desc limit 10 > ; ==> +-------------------------------------------------+ ==> | t.name | count | ==> +-------------------------------------------------+ ==> | "gezondheidsbeleid" | 1823 | ==> | "overtreding" | 1393 | ==> | "Europese organisatie" | 1389 | ==> | "EU-instantie" | 1323 | ==> | "mondiale organisatie" | 1277 | ==> | "gespecialiseerde instelling van de VN" | 1143 | ==> | "handeling van de EU" | 1129 | ==> | "internationaal publiekrecht" | 1091 | ==> | "sociaal beleid" | 971 | ==> | "rechtsvordering" | 915 | ==> +-------------------------------------------------+ ==> 10 rows *==> 8775 ms* *Your second Query* neo4j-sh (?)$ match (j:jurt)-[:HAS_TERM]->()-[:BT*0..]->(t2:term {name:{termname}}) return t.name, count(distinct j) as count order by count desc limit 10; ==> SyntaxException: t not defined (line 1, column 79) ==> "match (j:jurt)-[:HAS_TERM]->()-[:BT*0..]->(t2:term {name:{termname}}) return t.name, count(distinct j) as count order by count desc limit 10" ==> ^ neo4j-sh (?)$ match (j:jurt)-[:HAS_TERM]->()-[:BT*0..]->(t2:term {name:{termname}}) return t2.name, count(distinct j) as count order by count desc limit 10; ==> +-------------------+ ==> | t2.name | count | ==> +-------------------+ ==> | "Eurovoc" | 9576 | ==> +-------------------+ ==> 1 row *==> 3668 ms* But what I need is to include the docs on both the term I request and the count on its children, like this. I notice that the combination takes longer than the two separate queries combined. neo4j-sh (?)$ match (j:jurt)-[:HAS_TERM]->()-[:BT*0..]->(t:term)-[:BT*0..1]->(t2:term {name:{termname}}) return t.name, count(distinct j) as count order by count desc limit 10; ==> +-------------------------------------------------+ ==> | t.name | count | ==> +-------------------------------------------------+ ==> | "Eurovoc" | 9576 | ==> | "gezondheidsbeleid" | 1823 | ==> | "overtreding" | 1393 | ==> | "Europese organisatie" | 1389 | ==> | "EU-instantie" | 1323 | ==> | "mondiale organisatie" | 1277 | ==> | "gespecialiseerde instelling van de VN" | 1143 | ==> | "handeling van de EU" | 1129 | ==> | "internationaal publiekrecht" | 1091 | ==> | "sociaal beleid" | 971 | ==> +-------------------------------------------------+ ==> 10 rows *==> 17802 ms* -- 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+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.