Hi All,
So the new CREATE REPLICA TABLE definition / CREATE TABLE definition i'm not sure what the difference would be ?
CREATE REPLICA TABLE test2 AS (SELECT * FROM test) WITH DATA;
CREATE TABLE test2 AS (select * from test) WITH DATA;
Regards,
Brian Hood
On Tue, Sep 15, 2015 at 04:17:55PM +0100, Brian Hood wrote:
Hi All,
So the new CREATE REPLICA TABLE definition / CREATE TABLE definition i'm not sure what the difference would be ?
CREATE REPLICA TABLE test2 AS (SELECT * FROM test) WITH DATA;
CREATE TABLE test2 AS (select * from test) WITH DATA;
Regards,
Brian Hood
Brian
Replica tables shouldn't hold any data, they are meant to describe a set of tables which are all replica's. Using remote tables these could again be on different servers. The idea is to rewrite a query such that the local replica is used.
Niels
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (2)
-
Brian Hood
-
Niels Nes