Are there plans to support mixing databases in a cypher query

Feedback & Requests Neo4j 4.0
1

Will it be possible to combine results from multiple databases in a single query?
Hive and Spark for example support something like this:

SELECT sales.id, sales.amount, hr.id, hr.person FROM sales_db.sales AS sales 
INNER JOIN hr_db.employees as hr
ON hr.id = sales.id

where <databasename>.<table> syntax is used to combine databases.
Not sure how this would look in Cypher though

2

You can already do this today with apoc by using apoc.load.bolt.

Further developments in Neo4j itself will also enable querying multiple Neo4j databases. At that moment I cannot (yet) share any details on features or timeline.

1 Like