vld@vld:~$ parallel-ssh -iH "$hosts" 'echo "show create table fazze_youtube_parser.channel;" | clickhouse-client && echo "show create table fazze_youtube_parser.video;" | clickhouse-client && echo "show create table fazze_youtube_parser.url;" | clickhouse-client && echo "show create table fazze_youtube_parser.url_dirty;" | clickhouse-client && echo "show create table fazze_youtube_parser_shard.channel;" | clickhouse-client && echo "show create table fazze_youtube_parser_shard.video;" | clickhouse-client && echo "show create table fazze_youtube_parser_shard.url;" | clickhouse-client && echo "show create table fazze_youtube_parser_shard.url_dirty;" | clickhouse-client && echo "show create table fazze_youtube_parser_buffer.channel;" | clickhouse-client && echo "show create table fazze_youtube_parser_buffer.video;" | clickhouse-client && echo "show create table fazze_youtube_parser_buffer.url;" | clickhouse-client && echo "show create table fazze_youtube_parser_buffer.url_dirty;" | clickhouse-client'
[1] 16:04:14 [SUCCESS] f-clickhouse-n2
CREATE TABLE fazze_youtube_parser.channel ( channel_id String, name String, description String, image String, country String, subscribers UInt64, views UInt64, videos UInt64, created_at_date Date, created_at_time DateTime) ENGINE = Distributed(fornex_cluster, fazze_youtube_parser_buffer, channel, rand())
CREATE TABLE fazze_youtube_parser.video ( video_id String, channel_id String, name String, description String, category String, likes UInt64, dislikes UInt64, views UInt64, publication_date Date, created_at_date Date, created_at_time DateTime) ENGINE = Distributed(fornex_cluster, fazze_youtube_parser_buffer, video, rand())
CREATE TABLE fazze_youtube_parser.url ( channel_id String, video_id String, short_url String, final_url String, created_at_date Date, created_at_time DateTime) ENGINE = Distributed(fornex_cluster, fazze_youtube_parser_buffer, url, rand())
CREATE TABLE fazze_youtube_parser.url_dirty ( durl_url String, video_id String, created_at_date Date, created_at_time DateTime) ENGINE = Distributed(fornex_cluster, fazze_youtube_parser_buffer, url_dirty, rand())
CREATE TABLE fazze_youtube_parser_shard.channel ( channel_id String, name String, description String, image String, country String, subscribers UInt64, views UInt64, videos UInt64, created_at_date Date, created_at_time DateTime) ENGINE = ReplicatedMergeTree(\'/clickhouse/tables/{shard}/fazze_youtube_parser_shard/channel\', \'{replica}\', created_at_date, (channel_id, name), 8192)
CREATE TABLE fazze_youtube_parser_shard.video ( video_id String, channel_id String, name String, description String, category String, likes UInt64, dislikes UInt64, views UInt64, publication_date Date, created_at_date Date, created_at_time DateTime) ENGINE = ReplicatedMergeTree(\'/clickhouse/tables/{shard}/fazze_youtube_parser_shard/video\', \'{replica}\', created_at_date, (video_id, name), 8192)
CREATE TABLE fazze_youtube_parser_shard.url ( channel_id String, video_id String, short_url String, final_url String, created_at_date Date, created_at_time DateTime) ENGINE = ReplicatedMergeTree(\'/clickhouse/tables/{shard}/fazze_youtube_parser_shard/url\', \'{replica}\', created_at_date, (short_url, video_id), 8192)
CREATE TABLE fazze_youtube_parser_shard.url_dirty ( durl_url String, video_id String, created_at_date Date, created_at_time DateTime) ENGINE = ReplicatedMergeTree(\'/clickhouse/tables/{shard}/fazze_youtube_parser_shard/url_dirty\', \'{replica}\', created_at_date, (durl_url, video_id), 8192)
CREATE TABLE fazze_youtube_parser_buffer.channel ( channel_id String, name String, description String, image String, country String, subscribers UInt64, views UInt64, videos UInt64, created_at_date Date, created_at_time DateTime) ENGINE = Buffer(fazze_youtube_parser_shard, channel, 16, 10, 100, 10000, 1000000, 10000000, 100000000)
CREATE TABLE fazze_youtube_parser_buffer.video ( video_id String, channel_id String, name String, description String, category String, likes UInt64, dislikes UInt64, views UInt64, publication_date Date, created_at_date Date, created_at_time DateTime) ENGINE = Buffer(fazze_youtube_parser_shard, video, 16, 10, 100, 10000, 1000000, 10000000, 100000000)
CREATE TABLE fazze_youtube_parser_buffer.url ( channel_id String, video_id String, short_url String, final_url String, created_at_date Date, created_at_time DateTime) ENGINE = Buffer(fazze_youtube_parser_shard, url, 16, 10, 100, 10000, 1000000, 10000000, 100000000)
CREATE TABLE fazze_youtube_parser_buffer.url_dirty ( durl_url String, video_id String, created_at_date Date, created_at_time DateTime) ENGINE = Buffer(fazze_youtube_parser_shard, url_dirty, 16, 10, 100, 10000, 1000000, 10000000, 100000000)
[2] 16:04:14 [SUCCESS] f-clickhouse-n4
CREATE TABLE fazze_youtube_parser.channel ( channel_id String, name String, description String, image String, country String, subscribers UInt64, views UInt64, videos UInt64, created_at_date Date, created_at_time DateTime) ENGINE = Distributed(fornex_cluster, fazze_youtube_parser_buffer, channel, rand())
CREATE TABLE fazze_youtube_parser.video ( video_id String, channel_id String, name String, description String, category String, likes UInt64, dislikes UInt64, views UInt64, publication_date Date, created_at_date Date, created_at_time DateTime) ENGINE = Distributed(fornex_cluster, fazze_youtube_parser_buffer, video, rand())
CREATE TABLE fazze_youtube_parser.url ( channel_id String, video_id String, short_url String, final_url String, created_at_date Date, created_at_time DateTime) ENGINE = Distributed(fornex_cluster, fazze_youtube_parser_buffer, url, rand())
CREATE TABLE fazze_youtube_parser.url_dirty ( durl_url String, video_id String, created_at_date Date, created_at_time DateTime) ENGINE = Distributed(fornex_cluster, fazze_youtube_parser_buffer, url_dirty, rand())
CREATE TABLE fazze_youtube_parser_shard.channel ( channel_id String, name String, description String, image String, country String, subscribers UInt64, views UInt64, videos UInt64, created_at_date Date, created_at_time DateTime) ENGINE = ReplicatedMergeTree(\'/clickhouse/tables/{shard}/fazze_youtube_parser_shard/channel\', \'{replica}\', created_at_date, (channel_id, name), 8192)
CREATE TABLE fazze_youtube_parser_shard.video ( video_id String, channel_id String, name String, description String, category String, likes UInt64, dislikes UInt64, views UInt64, publication_date Date, created_at_date Date, created_at_time DateTime) ENGINE = ReplicatedMergeTree(\'/clickhouse/tables/{shard}/fazze_youtube_parser_shard/video\', \'{replica}\', created_at_date, (video_id, name), 8192)
CREATE TABLE fazze_youtube_parser_shard.url ( channel_id String, video_id String, short_url String, final_url String, created_at_date Date, created_at_time DateTime) ENGINE = ReplicatedMergeTree(\'/clickhouse/tables/{shard}/fazze_youtube_parser_shard/url\', \'{replica}\', created_at_date, (short_url, video_id), 8192)
CREATE TABLE fazze_youtube_parser_shard.url_dirty ( durl_url String, video_id String, created_at_date Date, created_at_time DateTime) ENGINE = ReplicatedMergeTree(\'/clickhouse/tables/{shard}/fazze_youtube_parser_shard/url_dirty\', \'{replica}\', created_at_date, (durl_url, video_id), 8192)
CREATE TABLE fazze_youtube_parser_buffer.channel ( channel_id String, name String, description String, image String, country String, subscribers UInt64, views UInt64, videos UInt64, created_at_date Date, created_at_time DateTime) ENGINE = Buffer(fazze_youtube_parser_shard, channel, 16, 10, 100, 10000, 1000000, 10000000, 100000000)
CREATE TABLE fazze_youtube_parser_buffer.video ( video_id String, channel_id String, name String, description String, category String, likes UInt64, dislikes UInt64, views UInt64, publication_date Date, created_at_date Date, created_at_time DateTime) ENGINE = Buffer(fazze_youtube_parser_shard, video, 16, 10, 100, 10000, 1000000, 10000000, 100000000)
CREATE TABLE fazze_youtube_parser_buffer.url ( channel_id String, video_id String, short_url String, final_url String, created_at_date Date, created_at_time DateTime) ENGINE = Buffer(fazze_youtube_parser_shard, url, 16, 10, 100, 10000, 1000000, 10000000, 100000000)
CREATE TABLE fazze_youtube_parser_buffer.url_dirty ( durl_url String, video_id String, created_at_date Date, created_at_time DateTime) ENGINE = Buffer(fazze_youtube_parser_shard, url_dirty, 16, 10, 100, 10000, 1000000, 10000000, 100000000)
[3] 16:04:14 [SUCCESS] f-clickhouse-n3
CREATE TABLE fazze_youtube_parser.channel ( channel_id String, name String, description String, image String, country String, subscribers UInt64, views UInt64, videos UInt64, created_at_date Date, created_at_time DateTime) ENGINE = Distributed(fornex_cluster, fazze_youtube_parser_buffer, channel, rand())
CREATE TABLE fazze_youtube_parser.video ( video_id String, channel_id String, name String, description String, category String, likes UInt64, dislikes UInt64, views UInt64, publication_date Date, created_at_date Date, created_at_time DateTime) ENGINE = Distributed(fornex_cluster, fazze_youtube_parser_buffer, video, rand())
CREATE TABLE fazze_youtube_parser.url ( channel_id String, video_id String, short_url String, final_url String, created_at_date Date, created_at_time DateTime) ENGINE = Distributed(fornex_cluster, fazze_youtube_parser_buffer, url, rand())
CREATE TABLE fazze_youtube_parser.url_dirty ( durl_url String, video_id String, created_at_date Date, created_at_time DateTime) ENGINE = Distributed(fornex_cluster, fazze_youtube_parser_buffer, url_dirty, rand())
CREATE TABLE fazze_youtube_parser_shard.channel ( channel_id String, name String, description String, image String, country String, subscribers UInt64, views UInt64, videos UInt64, created_at_date Date, created_at_time DateTime) ENGINE = ReplicatedMergeTree(\'/clickhouse/tables/{shard}/fazze_youtube_parser_shard/channel\', \'{replica}\', created_at_date, (channel_id, name), 8192)
CREATE TABLE fazze_youtube_parser_shard.video ( video_id String, channel_id String, name String, description String, category String, likes UInt64, dislikes UInt64, views UInt64, publication_date Date, created_at_date Date, created_at_time DateTime) ENGINE = ReplicatedMergeTree(\'/clickhouse/tables/{shard}/fazze_youtube_parser_shard/video\', \'{replica}\', created_at_date, (video_id, name), 8192)
CREATE TABLE fazze_youtube_parser_shard.url ( channel_id String, video_id String, short_url String, final_url String, created_at_date Date, created_at_time DateTime) ENGINE = ReplicatedMergeTree(\'/clickhouse/tables/{shard}/fazze_youtube_parser_shard/url\', \'{replica}\', created_at_date, (short_url, video_id), 8192)
CREATE TABLE fazze_youtube_parser_shard.url_dirty ( durl_url String, video_id String, created_at_date Date, created_at_time DateTime) ENGINE = ReplicatedMergeTree(\'/clickhouse/tables/{shard}/fazze_youtube_parser_shard/url_dirty\', \'{replica}\', created_at_date, (durl_url, video_id), 8192)
CREATE TABLE fazze_youtube_parser_buffer.channel ( channel_id String, name String, description String, image String, country String, subscribers UInt64, views UInt64, videos UInt64, created_at_date Date, created_at_time DateTime) ENGINE = Buffer(fazze_youtube_parser_shard, channel, 16, 10, 100, 10000, 1000000, 10000000, 100000000)
CREATE TABLE fazze_youtube_parser_buffer.video ( video_id String, channel_id String, name String, description String, category String, likes UInt64, dislikes UInt64, views UInt64, publication_date Date, created_at_date Date, created_at_time DateTime) ENGINE = Buffer(fazze_youtube_parser_shard, video, 16, 10, 100, 10000, 1000000, 10000000, 100000000)
CREATE TABLE fazze_youtube_parser_buffer.url ( channel_id String, video_id String, short_url String, final_url String, created_at_date Date, created_at_time DateTime) ENGINE = Buffer(fazze_youtube_parser_shard, url, 16, 10, 100, 10000, 1000000, 10000000, 100000000)
CREATE TABLE fazze_youtube_parser_buffer.url_dirty ( durl_url String, video_id String, created_at_date Date, created_at_time DateTime) ENGINE = Buffer(fazze_youtube_parser_shard, url_dirty, 16, 10, 100, 10000, 1000000, 10000000, 100000000)
[4] 16:04:15 [SUCCESS] f-clickhouse-n1
CREATE TABLE fazze_youtube_parser.channel ( channel_id String, name String, description String, image String, country String, subscribers UInt64, views UInt64, videos UInt64, created_at_date Date, created_at_time DateTime) ENGINE = Distributed(fornex_cluster, fazze_youtube_parser_buffer, channel, rand())
CREATE TABLE fazze_youtube_parser.video ( video_id String, channel_id String, name String, description String, category String, likes UInt64, dislikes UInt64, views UInt64, publication_date Date, created_at_date Date, created_at_time DateTime) ENGINE = Distributed(fornex_cluster, fazze_youtube_parser_buffer, video, rand())
CREATE TABLE fazze_youtube_parser.url ( channel_id String, video_id String, short_url String, final_url String, created_at_date Date, created_at_time DateTime) ENGINE = Distributed(fornex_cluster, fazze_youtube_parser_buffer, url, rand())
CREATE TABLE fazze_youtube_parser.url_dirty ( durl_url String, video_id String, created_at_date Date, created_at_time DateTime) ENGINE = Distributed(fornex_cluster, fazze_youtube_parser_buffer, url_dirty, rand())
CREATE TABLE fazze_youtube_parser_shard.channel ( channel_id String, name String, description String, image String, country String, subscribers UInt64, views UInt64, videos UInt64, created_at_date Date, created_at_time DateTime) ENGINE = ReplicatedMergeTree(\'/clickhouse/tables/{shard}/fazze_youtube_parser_shard/channel\', \'{replica}\', created_at_date, (channel_id, name), 8192)
CREATE TABLE fazze_youtube_parser_shard.video ( video_id String, channel_id String, name String, description String, category String, likes UInt64, dislikes UInt64, views UInt64, publication_date Date, created_at_date Date, created_at_time DateTime) ENGINE = ReplicatedMergeTree(\'/clickhouse/tables/{shard}/fazze_youtube_parser_shard/video\', \'{replica}\', created_at_date, (video_id, name), 8192)
CREATE TABLE fazze_youtube_parser_shard.url ( channel_id String, video_id String, short_url String, final_url String, created_at_date Date, created_at_time DateTime) ENGINE = ReplicatedMergeTree(\'/clickhouse/tables/{shard}/fazze_youtube_parser_shard/url\', \'{replica}\', created_at_date, (short_url, video_id), 8192)
CREATE TABLE fazze_youtube_parser_shard.url_dirty ( durl_url String, video_id String, created_at_date Date, created_at_time DateTime) ENGINE = ReplicatedMergeTree(\'/clickhouse/tables/{shard}/fazze_youtube_parser_shard/url_dirty\', \'{replica}\', created_at_date, (durl_url, video_id), 8192)
CREATE TABLE fazze_youtube_parser_buffer.channel ( channel_id String, name String, description String, image String, country String, subscribers UInt64, views UInt64, videos UInt64, created_at_date Date, created_at_time DateTime) ENGINE = Buffer(fazze_youtube_parser_shard, channel, 16, 10, 100, 10000, 1000000, 10000000, 100000000)
CREATE TABLE fazze_youtube_parser_buffer.video ( video_id String, channel_id String, name String, description String, category String, likes UInt64, dislikes UInt64, views UInt64, publication_date Date, created_at_date Date, created_at_time DateTime) ENGINE = Buffer(fazze_youtube_parser_shard, video, 16, 10, 100, 10000, 1000000, 10000000, 100000000)
CREATE TABLE fazze_youtube_parser_buffer.url ( channel_id String, video_id String, short_url String, final_url String, created_at_date Date, created_at_time DateTime) ENGINE = Buffer(fazze_youtube_parser_shard, url, 16, 10, 100, 10000, 1000000, 10000000, 100000000)
CREATE TABLE fazze_youtube_parser_buffer.url_dirty ( durl_url String, video_id String, created_at_date Date, created_at_time DateTime) ENGINE = Buffer(fazze_youtube_parser_shard, url_dirty, 16, 10, 100, 10000, 1000000, 10000000, 100000000)
[5] 16:04:15 [SUCCESS] f-clickhouse-n5
CREATE TABLE fazze_youtube_parser.channel ( channel_id String, name String, description String, image String, country String, subscribers UInt64, views UInt64, videos UInt64, created_at_date Date, created_at_time DateTime) ENGINE = Distributed(fornex_cluster, fazze_youtube_parser_buffer, channel, rand())
CREATE TABLE fazze_youtube_parser.video ( video_id String, channel_id String, name String, description String, category String, likes UInt64, dislikes UInt64, views UInt64, publication_date Date, created_at_date Date, created_at_time DateTime) ENGINE = Distributed(fornex_cluster, fazze_youtube_parser_buffer, video, rand())
CREATE TABLE fazze_youtube_parser.url ( channel_id String, video_id String, short_url String, final_url String, created_at_date Date, created_at_time DateTime) ENGINE = Distributed(fornex_cluster, fazze_youtube_parser_buffer, url, rand())
CREATE TABLE fazze_youtube_parser.url_dirty ( durl_url String, video_id String, created_at_date Date, created_at_time DateTime) ENGINE = Distributed(fornex_cluster, fazze_youtube_parser_buffer, url_dirty, rand())
CREATE TABLE fazze_youtube_parser_shard.channel ( channel_id String, name String, description String, image String, country String, subscribers UInt64, views UInt64, videos UInt64, created_at_date Date, created_at_time DateTime) ENGINE = ReplicatedMergeTree(\'/clickhouse/tables/{shard}/fazze_youtube_parser_shard/channel\', \'{replica}\', created_at_date, (channel_id, name), 8192)
CREATE TABLE fazze_youtube_parser_shard.video ( video_id String, channel_id String, name String, description String, category String, likes UInt64, dislikes UInt64, views UInt64, publication_date Date, created_at_date Date, created_at_time DateTime) ENGINE = ReplicatedMergeTree(\'/clickhouse/tables/{shard}/fazze_youtube_parser_shard/video\', \'{replica}\', created_at_date, (video_id, name), 8192)
CREATE TABLE fazze_youtube_parser_shard.url ( channel_id String, video_id String, short_url String, final_url String, created_at_date Date, created_at_time DateTime) ENGINE = ReplicatedMergeTree(\'/clickhouse/tables/{shard}/fazze_youtube_parser_shard/url\', \'{replica}\', created_at_date, (short_url, video_id), 8192)
CREATE TABLE fazze_youtube_parser_shard.url_dirty ( durl_url String, video_id String, created_at_date Date, created_at_time DateTime) ENGINE = ReplicatedMergeTree(\'/clickhouse/tables/{shard}/fazze_youtube_parser_shard/url_dirty\', \'{replica}\', created_at_date, (durl_url, video_id), 8192)
CREATE TABLE fazze_youtube_parser_buffer.channel ( channel_id String, name String, description String, image String, country String, subscribers UInt64, views UInt64, videos UInt64, created_at_date Date, created_at_time DateTime) ENGINE = Buffer(fazze_youtube_parser_shard, channel, 16, 10, 100, 10000, 1000000, 10000000, 100000000)
CREATE TABLE fazze_youtube_parser_buffer.video ( video_id String, channel_id String, name String, description String, category String, likes UInt64, dislikes UInt64, views UInt64, publication_date Date, created_at_date Date, created_at_time DateTime) ENGINE = Buffer(fazze_youtube_parser_shard, video, 16, 10, 100, 10000, 1000000, 10000000, 100000000)
CREATE TABLE fazze_youtube_parser_buffer.url ( channel_id String, video_id String, short_url String, final_url String, created_at_date Date, created_at_time DateTime) ENGINE = Buffer(fazze_youtube_parser_shard, url, 16, 10, 100, 10000, 1000000, 10000000, 100000000)
CREATE TABLE fazze_youtube_parser_buffer.url_dirty ( durl_url String, video_id String, created_at_date Date, created_at_time DateTime) ENGINE = Buffer(fazze_youtube_parser_shard, url_dirty, 16, 10, 100, 10000, 1000000, 10000000, 100000000)
[6] 16:04:15 [SUCCESS] f-clickhouse-n6
CREATE TABLE fazze_youtube_parser.channel ( channel_id String, name String, description String, image String, country String, subscribers UInt64, views UInt64, videos UInt64, created_at_date Date, created_at_time DateTime) ENGINE = Distributed(fornex_cluster, fazze_youtube_parser_buffer, channel, rand())
CREATE TABLE fazze_youtube_parser.video ( video_id String, channel_id String, name String, description String, category String, likes UInt64, dislikes UInt64, views UInt64, publication_date Date, created_at_date Date, created_at_time DateTime) ENGINE = Distributed(fornex_cluster, fazze_youtube_parser_buffer, video, rand())
CREATE TABLE fazze_youtube_parser.url ( channel_id String, video_id String, short_url String, final_url String, created_at_date Date, created_at_time DateTime) ENGINE = Distributed(fornex_cluster, fazze_youtube_parser_buffer, url, rand())
CREATE TABLE fazze_youtube_parser.url_dirty ( durl_url String, video_id String, created_at_date Date, created_at_time DateTime) ENGINE = Distributed(fornex_cluster, fazze_youtube_parser_buffer, url_dirty, rand())
CREATE TABLE fazze_youtube_parser_shard.channel ( channel_id String, name String, description String, image String, country String, subscribers UInt64, views UInt64, videos UInt64, created_at_date Date, created_at_time DateTime) ENGINE = ReplicatedMergeTree(\'/clickhouse/tables/{shard}/fazze_youtube_parser_shard/channel\', \'{replica}\', created_at_date, (channel_id, name), 8192)
CREATE TABLE fazze_youtube_parser_shard.video ( video_id String, channel_id String, name String, description String, category String, likes UInt64, dislikes UInt64, views UInt64, publication_date Date, created_at_date Date, created_at_time DateTime) ENGINE = ReplicatedMergeTree(\'/clickhouse/tables/{shard}/fazze_youtube_parser_shard/video\', \'{replica}\', created_at_date, (video_id, name), 8192)
CREATE TABLE fazze_youtube_parser_shard.url ( channel_id String, video_id String, short_url String, final_url String, created_at_date Date, created_at_time DateTime) ENGINE = ReplicatedMergeTree(\'/clickhouse/tables/{shard}/fazze_youtube_parser_shard/url\', \'{replica}\', created_at_date, (short_url, video_id), 8192)
CREATE TABLE fazze_youtube_parser_shard.url_dirty ( durl_url String, video_id String, created_at_date Date, created_at_time DateTime) ENGINE = ReplicatedMergeTree(\'/clickhouse/tables/{shard}/fazze_youtube_parser_shard/url_dirty\', \'{replica}\', created_at_date, (durl_url, video_id), 8192)
CREATE TABLE fazze_youtube_parser_buffer.channel ( channel_id String, name String, description String, image String, country String, subscribers UInt64, views UInt64, videos UInt64, created_at_date Date, created_at_time DateTime) ENGINE = Buffer(fazze_youtube_parser_shard, channel, 16, 10, 100, 10000, 1000000, 10000000, 100000000)
CREATE TABLE fazze_youtube_parser_buffer.video ( video_id String, channel_id String, name String, description String, category String, likes UInt64, dislikes UInt64, views UInt64, publication_date Date, created_at_date Date, created_at_time DateTime) ENGINE = Buffer(fazze_youtube_parser_shard, video, 16, 10, 100, 10000, 1000000, 10000000, 100000000)
CREATE TABLE fazze_youtube_parser_buffer.url ( channel_id String, video_id String, short_url String, final_url String, created_at_date Date, created_at_time DateTime) ENGINE = Buffer(fazze_youtube_parser_shard, url, 16, 10, 100, 10000, 1000000, 10000000, 100000000)
CREATE TABLE fazze_youtube_parser_buffer.url_dirty ( durl_url String, video_id String, created_at_date Date, created_at_time DateTime) ENGINE = Buffer(fazze_youtube_parser_shard, url_dirty, 16, 10, 100, 10000, 1000000, 10000000, 100000000)
Comments