ClickHouse / examples

ClickHouse Examples
Apache License 2.0
107 stars 24 forks source link

[docker-recipes] Add ch_1S_1K #90

Closed nellicus closed 9 months ago

nellicus commented 9 months ago

Adds 1 ch node with 1 keeper node

➜  ch-1S_1K git:(ch_1S_1K) ✗ docker compose up
[+] Running 17/17
 ✔ clickhouse-keeper 6 layers [⣿⣿⣿⣿⣿⣿]      0B/0B      Pulled                                                                                    7.6s
   ✔ 2c03dbb20264 Pull complete                                                                                                                  2.8s
   ✔ 5920502e0ef1 Pull complete                                                                                                                  3.0s
   ✔ b08ff4ec8fbe Pull complete                                                                                                                  3.4s
   ✔ 458483ab9781 Pull complete                                                                                                                  3.6s
   ✔ e3f9298ffe06 Pull complete                                                                                                                  4.2s
   ✔ 0238be7f386f Pull complete                                                                                                                  4.7s
 ✔ clickhouse 9 layers [⣿⣿⣿⣿⣿⣿⣿⣿⣿]      0B/0B      Pulled                                                                                       10.9s
   ✔ dae58cbd668a Pull complete                                                                                                                  0.9s
   ✔ 0f9e2330634c Pull complete                                                                                                                  0.7s
   ✔ ebe664bc4f79 Pull complete                                                                                                                  4.8s
   ✔ 4f4fb700ef54 Pull complete                                                                                                                  1.2s
   ✔ af7e65dbf095 Pull complete                                                                                                                  1.5s
   ✔ 9b545470273b Pull complete                                                                                                                  1.9s
   ✔ a53be2573e98 Pull complete                                                                                                                  2.1s
   ✔ d594cefe717f Pull complete                                                                                                                  2.4s
   ✔ ef53d9003f87 Pull complete                                                                                                                  2.5s
[+] Running 3/2
 ✔ Network ch-1s_1k_default     Created                                                                                                          0.0s
 ✔ Container clickhouse-keeper  Created                                                                                                          0.1s
 ✔ Container clickhouse         Created                                                                                                          0.1s
Attaching to clickhouse, clickhouse-keeper
clickhouse-keeper  | Processing configuration file '/etc/clickhouse-keeper/keeper_config.xml'.
clickhouse-keeper  | Logging information to /var/log/clickhouse-keeper/clickhouse-keeper.log
clickhouse-keeper  | Logging errors to /var/log/clickhouse-keeper/clickhouse-keeper.err.log
clickhouse         | Processing configuration file '/etc/clickhouse-server/config.xml'.
clickhouse         | Merging configuration file '/etc/clickhouse-server/config.d/config.xml'.
clickhouse         | Merging configuration file '/etc/clickhouse-server/config.d/docker_related_config.xml'.
clickhouse         | Logging debug to /var/log/clickhouse-server/clickhouse-server.log
clickhouse         | Logging errors to /var/log/clickhouse-server/clickhouse-server.err.log
clickhouse         | Processing configuration file '/etc/clickhouse-server/config.xml'.
clickhouse         | Merging configuration file '/etc/clickhouse-server/config.d/config.xml'.
clickhouse         | Merging configuration file '/etc/clickhouse-server/config.d/docker_related_config.xml'.
clickhouse         | Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/config.xml'.
clickhouse         | Processing configuration file '/etc/clickhouse-server/users.xml'.
clickhouse         | Merging configuration file '/etc/clickhouse-server/users.d/users.xml'.
clickhouse         | Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/users.xml'.
ch-1S_1K :) CREATE TABLE s3queue_engine_table
            (
                `name` String,
                `value` UInt32
            )
            ENGINE = S3Queue('https://XXXXXX.XXXX/XXXXXXXXXXXX/*', 'CSV', 'gzip')
            SETTINGS mode = 'unordered'

CREATE TABLE s3queue_engine_table
(
    `name` String,
    `value` UInt32
)
ENGINE = S3Queue('https://XXXXXX.XXXX/XXXXXXXXXXXX/*', 'CSV', 'gzip')
SETTINGS mode = 'unordered'

Query id: d86bd7a4-340a-4f62-928a-2cb7552beec6

Ok.

0 rows in set. Elapsed: 4.057 sec