Is it possible to access two databases in a single select?
Is this possible in MonetDB? select * from database1.table1 t1, database2.table2 t2 where t1.col1 = t2.col2 where database1 and database2 are two databases running simultaneously.
Yes, if you make use of REMOTE TABLE functionality. See: https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/DistributedQueryP... You need to run two mserver5 RDBMS processes, each accessing and managing its own database. If those processes run on the same OS they will need to be started with different port numbers. Note that it is not possible to specify the database name in the fully qualified table name: database1.table1. Only schemas are supported in fully qualified table names, as in: schema1.table1. On 21-08-16 03:44, Pablo S wrote:
Is this possible in MonetDB?
select * from database1.table1 t1, database2.table2 t2 where t1.col1 = t2.col2
where database1 and database2 are two databases running simultaneously.
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (2)
-
martin van dinther -
Pablo S