Hi,
Myself Rajat, Software Engineer in a Startup from India.
Using Neo4j for our recommendation system, recently started working on it.
Still learning the cypher ways.
Looking for all the help I can get.
Cheers
Neo4j Version: 3.5.0
Trying to get sum on a node property
MATCH (a:Author)-[p:Published]->(b:Book)
WITH a.author_id AS author_id, SUM(b.read_count) AS total_read_count
WHERE total_read_count < 500
RETURN author_id, total_read_count
have indexes o...
The counts are shown different by a good margin at a particular time
How is that possible?
The label count() shows less number compared to exists count()
neo4j> MATCH (n:User) where exists(n.user_id) RETURN count(*);
+----------+
| count(*) |
+------...
@dana.canzano Sure will see if we can update
I don't know why we have a large heap size, since it was already implemented. Will let you know when I come to know about it.
andrew.bowman:
Match (b:Book)<-[:Published]-(a:Author) where b.read_count >= 500 with collect(DISTINCT a) as filteredOutAuthors match (b)<-[:Published]-(a:Author) WHERE NOT a IN filteredOutAuthors WITH a, SUM(b.read_count) AS total_read_count WH...
@michael.hunger neo4j version 3.5.0
Will try creating a native index
Attaching the profile of @dana.canzano suggestion
this query took this much time Started streaming 110570 records after 35529 ms and completed after 35659 ms, displaying first 10...
