yeah.. found that out too .. profiled things are already in groups.
Met vriendelijke groet / With kind regards
Ir. T. Zeppenfeldt
van der Waalsstraat 30
6706 JR Wageningen
The Netherlands
Mobile: +31 6 23 28 78 06
Phone: +31 3 17 84 22 17
E-mail: t.zeppenfe...@ophileon.com
<t.zeppenfe...@ophileon.com>Web: www.ophileon.com
Twitter: tomzeppenfeldt
Skype: tomzeppenfeldt
2014-05-21 16:36 GMT+02:00 Michael Hunger <michael.hun...@neotechnology.com>
:
> Prefix your query with "profile "
>
> Sent from mobile device
>
> Am 21.05.2014 um 15:40 schrieb Tom Zeppenfeldt <tomzeppenfe...@gmail.com>:
>
> 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.
>
> --
> 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.
>
--
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.
