Ah, you want MERGE TABLEs, in combination with REMOTE TABLEs. See https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/DataPartitioning and https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/DistributedQueryP... You can build a merge table out of remote tables :) There have been some bugs recently so be sure to use the most recent version of MonetDB. Joeri On Tue, Oct 17, 2017 at 03:02:34PM +0000, Sharma, Sreejith wrote:
Hi Joeri,
If we need to load balance, we can have the same tables sitting over 2 tablesspaces or 2 servers. This can help balance the load coming into same server and can share the load within servers.
Sreejith
From: users-list [mailto:users-list-bounces+sreejith.sharma=harman.com@monetdb.org] On Behalf Of Joeri van Ruth Sent: Tuesday, October 17, 2017 8:22 PM To: Communication channel for MonetDB users Subject: [EXTERNAL] Re: Is there kind of tablespace concepts?
On 17 October 2017 at 14:35:55, Sharma, Sreejith (sreejith.sharma@harman.commailto:sreejith.sharma@harman.com) wrote: Hi All, Is there any possibility of retrieving the same table from 2 different sources (as similar to 2 tablespaces)? Regards, Sreejith _______________________________________________ users-list mailing list users-list@monetdb.orgmailto:users-list@monetdb.org https://clicktime.symantec.com/a/1/pu_KcYJjKrAPr1ZJTrJX4mkXH5s5kNf2dMmjHkWvMTc=?d=KbDls4KNqlWYTMpZa_vsXJVosCwx3_ZQAudONf22lbjWZt1DSDn6apwp2Fqv2JnUgjVqAWy77gk8LAraRcuDR_I6Ke87N4ha21c68C13nsfV1TXpi2aTBUL_YMqySQL_vd53WMk9QTn9go1kmTEeVc21uSmjrZT0kA4Tx9E1ygHevsYK6nxzPR-ScW3Ueh1tBzi1L33G5WqLMPtlRHFxpsT7mbwRqvBN9rAnK5BJ3m0vddOXbl-DNLQW-ZKSmpsLkwK0bFE9jx8HTw4OrUFjMuxBsktljqRMpG9wS2Nak1_qRYyg1-6--GHKKMAOpD99yn1XeG3e1Zm4uKf_-w3zUllOyxhx3TbExXZN_LkaR4ynPsJFNJLEj_36S1Gb3ZSg1rAj-6UnA04cCJ7uavDYddGLQMPxnXzS8BR4kQblv2xLO_QS8uDw9uus&u=https%3A%2F%2Fwww.monetdb.org%2Fmailman%2Flistinfo%2Fusers-list
Hi Sharma!
I’m not entirely sure what you mean with same table from 2 sources, could you give a more detailed example?
Joeri
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list