You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Thanks! Basic tests now produce expected results. How can I create a test for this? The queries + mclient commands used and the output are the following:
sql>CREATE TABLE t1 (i int);
operation successful (2.068ms)
Date: 2015-07-21 11:15:31 +0200
From: @yzchang
To: clients devs <>
Version: -- development
CC: @yzchang
Last updated: 2020-11-12 14:47:42 +0100
Comment 21031
Date: 2015-07-21 11:15:31 +0200
From: @yzchang
mclient is unaware of merge/remote tables yet. Issues found so far:
sql>\d t5
mapi:monetdb://localhost:50000/test
Documentation for how to create merge/remote tables are here:
https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/DataPartitioning
https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/DistributedQueryProcessing
Comment 21044
Date: 2015-07-22 16:23:59 +0200
From: @sjoerdmullender
Changesets 91643b6a257e f0ba0766ac53 and 01cd8cd56d15 implement this feature.
Do they work satisfactorily?
Comment 21054
Date: 2015-07-23 11:30:52 +0200
From: @yzchang
Thanks! Basic tests now produce expected results. How can I create a test for this? The queries + mclient commands used and the output are the following:
sql>CREATE TABLE t1 (i int);
operation successful (2.068ms)
sql>CREATE MERGE TABLE mt1 (t int);
operation successful (1.737ms)
sql>ALTER TABLE mt1 ADD TABLE t1;
operation successful (1.220ms)
sql>CREATE REMOTE TABLE rt1 (t int) on 'mapi:monetdb://localhost:50000/test';
operation successful (2.064ms)
sql>\d
MERGE TABLE sys.mt1
REMOTE TABLE sys.rt1
TABLE sys.t1
sql>\d mt1
CREATE MERGE TABLE "sys"."mt1" (
"t" INTEGER
);
sql>\d rt1
CREATE REMOTE TABLE "sys"."rt1" (
"t" INTEGER
) ON 'mapi:monetdb://localhost:50000/test';
sql>\D
START TRANSACTION;
SET SCHEMA "sys";
CREATE TABLE "sys"."t1" (
"i" INTEGER
);
CREATE MERGE TABLE "sys"."mt1" (
"t" INTEGER
);
CREATE REMOTE TABLE "sys"."rt1" (
"t" INTEGER
) ON 'mapi:monetdb://localhost:50000/test';
ALTER TABLE "sys"."mt1" ADD TABLE "t1";
COMMIT;
Comment 21213
Date: 2015-08-28 13:42:32 +0200
From: @sjoerdmullender
Jul2015 has been released.
Comment 21527
Date: 2015-11-16 16:06:21 +0100
From: MonetDB Mercurial Repository <>
Changeset 95d728adb4b9 made by Jennie Zhang y.zhang@cwi.nl in the MonetDB repo, refers to this bug.
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=95d728adb4b9
Changeset description:
Comment 28259
Date: 2020-11-12 14:47:42 +0100
From: MonetDB Mercurial Repository <>
Changeset 9711b482487e made by Pedro Ferreira pedro.ferreira@monetdbsolutions.com in the MonetDB repo, refers to this bug.
For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=9711b482487e
Changeset description:
The text was updated successfully, but these errors were encountered: