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

Using 'OR' and 'AND' in SQL Server -

-
is using ( condition or condition b , condition c ) the same as ( condition , condition c) or (condition b , condition c) no. first condition is: (condition a) or (condition b , condition c) and second is: (condition , condition c) or (condition b , condition c) you can see difference between them.
Read more

c++ - NetBeans Remote Development with additional configuration -

-
i'm trying use netbeans (7.3.1) work on remote project. my configuration following: my local machine windows 7 laptop. doesn't have tools. in particular neither compiler nor debugger. have netbeans ide , putty example. source code, make scripts , (eventually) build results located on remote storage shared across servers , "locals". (i might switch single server storage faster don't think matters @ all.) i'm accessing using sshfs manager . sshfs manager takes server name, path on server, user name , ssh private key. in result mounts directory on server disk on windows. works fine. (although directories, possibly links, represented files in windows explorer, don't know if matters...) netbeans project located on local machine don't think matters , place remotely well. prefer keep "off source" don't have add ignores version control. in netbeans did procedure described in remote developement tutorial . seems successful. netbeans c...
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