SQL join involving remote table.
Hi, According to https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/DistributedQueryP... It is said that, "Queries involving remote tables are automatically split into subqueries by the master database and executed on remote databases.". I think this scenario: I have 3 server, one master server and two worker servers. I have 2 tables, A (big one, a fact table) and B (small one, a dimension table). A is a merge table of 2 remote tables. The remote table exist in two worker servers. B is a dimension table, that I'm not sure, on which server, I should place it on. And I will do queries, that join A and B. On which server, I should place table B to achieve distributed query processing? Is table B should be replicated on all remote table? Thanks, -Aris
On Thu, Oct 15, 2015 at 11:37:34PM +0700, Aris Setyawan wrote:
Hi,
According to https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/DistributedQueryP... It is said that, "Queries involving remote tables are automatically split into subqueries by the master database and executed on remote databases.".
I think this scenario:
I have 3 server, one master server and two worker servers.
I have 2 tables, A (big one, a fact table) and B (small one, a dimension table). A is a merge table of 2 remote tables. The remote table exist in two worker servers. B is a dimension table, that I'm not sure, on which server, I should place it on.
And I will do queries, that join A and B.
On which server, I should place table B to achieve distributed query processing? Is table B should be replicated on all remote table? yes replicated using 'replica' tables. On the master you define the replica table. Using alter you can add the 'remote' replicated tables.
Niels
Thanks, -Aris _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- Niels Nes, Manager ITF, Centrum Wiskunde & Informatica (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nl url: https://www.cwi.nl/people/niels e-mail: Niels.Nes@cwi.nl
Ok, so it is already supported.
Thanks.
Aris
On 10/16/15, Niels Nes
On Thu, Oct 15, 2015 at 11:37:34PM +0700, Aris Setyawan wrote:
Hi,
According to https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/DistributedQueryP... It is said that, "Queries involving remote tables are automatically split into subqueries by the master database and executed on remote databases.".
I think this scenario:
I have 3 server, one master server and two worker servers.
I have 2 tables, A (big one, a fact table) and B (small one, a dimension table). A is a merge table of 2 remote tables. The remote table exist in two worker servers. B is a dimension table, that I'm not sure, on which server, I should place it on.
And I will do queries, that join A and B.
On which server, I should place table B to achieve distributed query processing? Is table B should be replicated on all remote table? yes replicated using 'replica' tables. On the master you define the replica table. Using alter you can add the 'remote' replicated tables.
Niels
Thanks, -Aris _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- Niels Nes, Manager ITF, Centrum Wiskunde & Informatica (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nl url: https://www.cwi.nl/people/niels e-mail: Niels.Nes@cwi.nl _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (2)
-
Aris Setyawan -
Niels Nes