Limit the results of a union cypher query

Question

Let's say we have the example query from the documentation:

MATCH (n:Actor)
RETURN n.name AS name
UNION
MATCH (n:Movie)
RETURN n.title AS name

I know that if I do that:

MATCH (n:Actor)
RETURN n.name AS name
LIMIT 5
UNION
MATCH (n:Movie)
RETURN n.title AS name
LIMIT 5

I can reduce the returned results of each sub query to 5.How can I LIMIT the total results of the union query?

Answer 1

This is not yet possible, but there is already an open neo4j issue that requests the ability to do post-UNION processing, which includes what you are asking about. You can add a comment to that neo4j issue if you support having it resolved.