Neo4j聚合函数 [英] Neo4j aggregate function

问题描述

我正在尝试使用SUM函数并将其结果存储为关系的新属性.但这是行不通的. 我使用的查询是:

I am trying to use the SUM function and store the result of it as a new property of the relationship. But it is not working. The query I used is :

MATCH (a:Employee)-[r:CorporateMessage]->(b)
WHERE a.Eid = 6001 AND b.Eid IN [6002,6003,6004,6005,5001]
SET r.Internalsum = SUM(r.Count)

我得到的错误是:

在这种情况下无效使用聚合函数sum(...)(第1行，第124列(偏移量:123))"MATCH(a:Employee)-[r:CorporateMessage]->(b) Eid = 6001 AND b.Eid IN [6002,6003,6004,6005,5001] SET r.Internalsum = SUM(r.Count)"

Invalid use of aggregating function sum(...) in this context (line 1, column 124 (offset: 123)) "MATCH (a:Employee)-[r:CorporateMessage]->(b)WHERE a.Eid = 6001 AND b.Eid IN [6002,6003,6004,6005,5001] SET r.Internalsum = SUM(r.Count)"

请解释我在做什么错.

推荐答案

尝试一下:

MATCH (a:Employee)-[r:CorporateMessage]->(b)
WHERE a.Eid = 6001 AND b.Eid IN [6002,6003,6004,6005,5001]
WITH r, SUM(r.count) as count
SET r.Internalsum = count

始终将聚合函数放入WITH或RETURN.

这篇关于Neo4j聚合函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！