Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- set -x
- curl clickhouse0:8123 -d "CREATE TABLE shard_1.foo_replicated(day Date, id String, x UInt32) ENGINE = ReplicatedMergeTree('/clickhouse/tables/1/foo_replicated', 'node1', day, (id), 8192)"
- curl clickhouse0:8123 -d "CREATE TABLE shard_2.foo_replicated(day Date, id String, x UInt32) ENGINE = ReplicatedMergeTree('/clickhouse/tables/2/foo_replicated', 'node1', day, (id), 8192)"
- curl clickhouse1:8123 -d "CREATE TABLE shard_0.foo_replicated(day Date, id String, x UInt32) ENGINE = ReplicatedMergeTree('/clickhouse/tables/0/foo_replicated', 'node2', day, (id), 8192)"
- curl clickhouse1:8123 -d "CREATE TABLE shard_2.foo_replicated(day Date, id String, x UInt32) ENGINE = ReplicatedMergeTree('/clickhouse/tables/2/foo_replicated', 'node2', day, (id), 8192)"
- curl clickhouse2:8123 -d "CREATE TABLE shard_0.foo_replicated(day Date, id String, x UInt32) ENGINE = ReplicatedMergeTree('/clickhouse/tables/0/foo_replicated', 'node0', day, (id), 8192)"
- curl clickhouse2:8123 -d "CREATE TABLE shard_1.foo_replicated(day Date, id String, x UInt32) ENGINE = ReplicatedMergeTree('/clickhouse/tables/1/foo_replicated', 'node0', day, (id), 8192)"
- curl clickhouse0:8123 -d "CREATE TABLE foo(day Date, id String, x UInt32) ENGINE = Distributed('my_cluster', '', foo_replicated, sipHash64(id))"
- curl clickhouse1:8123 -d "CREATE TABLE foo(day Date, id String, x UInt32) ENGINE = Distributed('my_cluster', '', foo_replicated, sipHash64(id))"
- curl clickhouse2:8123 -d "CREATE TABLE foo(day Date, id String, x UInt32) ENGINE = Distributed('my_cluster', '', foo_replicated, sipHash64(id))"
- curl clickhouse0:8123 -d "CREATE TABLE shard_1.bar_replicated(day Date, id String, x UInt32) ENGINE = ReplicatedMergeTree('/clickhouse/tables/1/bar_replicated', 'node1', day, (id), 8192)"
- curl clickhouse0:8123 -d "CREATE TABLE shard_2.bar_replicated(day Date, id String, x UInt32) ENGINE = ReplicatedMergeTree('/clickhouse/tables/2/bar_replicated', 'node1', day, (id), 8192)"
- curl clickhouse1:8123 -d "CREATE TABLE shard_0.bar_replicated(day Date, id String, x UInt32) ENGINE = ReplicatedMergeTree('/clickhouse/tables/0/bar_replicated', 'node2', day, (id), 8192)"
- curl clickhouse1:8123 -d "CREATE TABLE shard_2.bar_replicated(day Date, id String, x UInt32) ENGINE = ReplicatedMergeTree('/clickhouse/tables/2/bar_replicated', 'node2', day, (id), 8192)"
- curl clickhouse2:8123 -d "CREATE TABLE shard_0.bar_replicated(day Date, id String, x UInt32) ENGINE = ReplicatedMergeTree('/clickhouse/tables/0/bar_replicated', 'node0', day, (id), 8192)"
- curl clickhouse2:8123 -d "CREATE TABLE shard_1.bar_replicated(day Date, id String, x UInt32) ENGINE = ReplicatedMergeTree('/clickhouse/tables/1/bar_replicated', 'node0', day, (id), 8192)"
- curl clickhouse0:8123 -d "CREATE TABLE bar(day Date, id String, x UInt32) ENGINE = Distributed('my_cluster', '', bar_replicated, sipHash64(id))"
- curl clickhouse1:8123 -d "CREATE TABLE bar(day Date, id String, x UInt32) ENGINE = Distributed('my_cluster', '', bar_replicated, sipHash64(id))"
- curl clickhouse2:8123 -d "CREATE TABLE bar(day Date, id String, x UInt32) ENGINE = Distributed('my_cluster', '', bar_replicated, sipHash64(id))"
Add Comment
Please, Sign In to add comment