mclient is unaware of merge tables and remote tables

[monetdb-team]

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:

1. '\d' command does not show merge/remote tables. Merge/remote tables should be added as new types of tables.
2. '\d ' shows "CREATE TABLE" instead of "CREATE MERGE TABLE"
3. '\d ' shows only the remote URL part of a remote table, e.g.:

sql>\d t5
mapi:monetdb://localhost:50000/test

4. results of 'mclient -D' do not include merge/remote tables

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:

Added test for fixed bug #3774

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:

Converted msqldump-merge-and-remote-tables.Bug-3774 test