neo4j - Order nodes by relationship count --> ThisShouldNotHappenError -

-

in neo4j database couple of nodes , relationships, trying find out "popular" users (in case: nodes participating in relationships):

start n=node:user('*:*') match (n)-[r]->(x) return n order count(r) desc limit 10

however, query (neo4j 1.9.2) results in following error:

thisshouldnothappenerror

developer: andres claims that: aggregations should not used this.

stacktrace: org.neo4j.cypher.internal.commands.expressions.aggregationexpression.apply(aggregationexpression.scala:31) org.neo4j.cypher.internal.commands.expressions.aggregationexpression.apply(aggregationexpression.scala:29) org.neo4j.cypher.internal.pipes.extractpipe$$anonfun$internalcreateresults$1$$anonfun$apply$1.apply(extractpipe.scala:47) org.neo4j.cypher.internal.pipes.extractpipe$$anonfun$internalcreateresults$1$$anonfun$apply$1.apply(extractpipe.scala:45) scala.collection.immutable.map$map1.foreach(map.scala:109) org.neo4j.cypher.internal.pipes.extractpipe$$anonfun$internalcreateresults$1.apply(extractpipe.scala:45) org.neo4j.cypher.internal.pipes.extractpipe$$anonfun$internalcreateresults$1.apply(extractpipe.scala:44) scala.collection.iterator$$anon$11.next(iterator.scala:328) org.neo4j.cypher.internal.pipes.toppipe.internalcreateresults(toppipe.scala:45) org.neo4j.cypher.internal.pipes.pipewithsource.createresults(pipe.scala:69) org.neo4j.cypher.internal.pipes.pipewithsource.createresults(pipe.scala:66) org.neo4j.cypher.internal.executionplan.executionplanimpl.org$neo4j$cypher$internal$executionplan$executionplanimpl$$preparestateandresult(executionplanimpl.scala:164) org.neo4j.cypher.internal.executionplan.executionplanimpl$$anonfun$getlazyreadonlyquery$1.apply(executionplanimpl.scala:139) org.neo4j.cypher.internal.executionplan.executionplanimpl$$anonfun$getlazyreadonlyquery$1.apply(executionplanimpl.scala:138) org.neo4j.cypher.internal.executionplan.executionplanimpl.execute(executionplanimpl.scala:38) org.neo4j.cypher.executionengine.execute(executionengine.scala:72) org.neo4j.cypher.executionengine.execute(executionengine.scala:76) org.neo4j.cypher.javacompat.executionengine.execute(executionengine.java:79) org.neo4j.server.rest.web.cypherservice.cypher(cypherservice.java:94) java.lang.reflect.method.invoke(method.java:611) org.neo4j.server.rest.security.securityfilter.dofilter(securityfilter.java:112)

any ideas on how can express differntly?

in terms of neo4j mannual, if need use aggregration in "order by", must include aggregration in "return", need add count(r) in "return" shown below, 

start n=node:user('*:*') match (n)-[r]->(x) return n, count(r) order count(r) desc limit 10

Comments

Post a Comment

Popular posts from this blog

java - How to Configure JAXRS and Spring With Annotations -

-
i working on little spring web service project. here example route: package com.example.api; import javax.ws.rs.get; import javax.ws.rs.path; import javax.ws.rs.produces; import javax.ws.rs.pathparam; import javax.ws.rs.ext.provider; import javax.ws.rs.core.mediatype; @provider public class webserviceroutes { @get @path("/hello") public string health() { return "hello"; } } then in spring configuration class: package com.example.api; import org.springframework.context.annotation.bean; import org.springframework.context.annotation.configuration; @configuration public class springcontextconfiguration { @bean( destroymethod = "shutdown" ) public springbus cxf() { return new springbus(); } @bean public webserviceroutes webserviceroutes() { return new webserviceroutes(); } } and in web.xml: <?xml version="1.0" encoding="utf-8"?> <web-app version=...
Read more

visual studio - TFS will not accept changes I've made to a Java project -

-
i using tfs's team explorer manage visual studio projects. recently, i've created new java project (not in visual studio) manually added tfs using source control control explorer in visual studio. after added java project tfs, made changes , bug fixes. then, went visual studio , opened source control explorer check in changes, tfs thinks no changes made. it seems needed check out project before making changes. guess erroneously expected tfs track automatically, okay. so, using source control explorer in tfs, checked out project, , tried check in pending changes. when tried check in, got following message: all of changes either unmodified files or locks. changes have been undone server. is there way convince server indeed project has changed? how can check in changes have made? thank help.
Read more

php - Create image in codeigniter on the fly -

-
i want create image in codeigniter in simple php using gd functions. have tried following method in controller function image(){ $my_img = imagecreate( 200, 80 ); $background = imagecolorallocate( $my_img, 0, 0, 255 ); $text_colour = imagecolorallocate( $my_img, 255, 255, 0 ); $line_colour = imagecolorallocate( $my_img, 128, 255, 0 ); imagestring( $my_img, 4, 30, 25, "thesitewizard.com", $text_colour ); imagesetthickness ( $my_img, 5 ); imageline( $my_img, 30, 45, 165, 45, $line_colour ); //$this->output->set_content_type('image/png'); header( "content-type: image/png" ); imagepng( $my_img ); imagecolordeallocate( $line_color ); imagecolordeallocate( $text_color ); imagecolordeallocate( $background ); imagedestroy( $my_img ); } if write code in simple php can see in url http://www.domain.com/image.php if run in codeignite...
Read more