New Page

CREATE TABLE my_table ON CLUSTER default

(

`id` UInt64,

`name` String,

`created_at` String

)

ENGINE = MergeTree

ORDER BY id

INSERT INTO demo.my_table

(id, name, created_at)

VALUES(0, '228', '');

select * from my_table

INSERT INTO demo.my_table_all

(id, name, created_at)

VALUES(0, 'X', '');

CREATE TABLE my_table_all ON CLUSTER default AS my_table

ENGINE = Distributed(default, demo, my_table, rand())

select * from my_table_all