Clickhouse简单操作

clickhouse的默认用户："default" 密码是："" 空字符串。

如下是我本地docker操作：

C:\Users\boonya>docker exec -it clickhouse /bin/bash
root@11e7771e482c:/# exit
exit

C:\Users\boonya>docker run -it --rm --link clickhouse-test-server:clickhouse-server yandex/clickhouse-client --host clickhouse-server
docker: Error response from daemon: could not get container for clickhouse-test-server: No such container: clickhouse-test-server.
See 'docker run --help'.

C:\Users\boonya>docker run -it --rm --link clickhouse:clickhouse-server yandex/clickhouse-client --host clickhouse
ClickHouse client version 22.1.3.7 (official build).
Connecting to clickhouse:9000 as user default.
Connected to ClickHouse server version 22.1.3 revision 54455.

11e7771e482c :) show tables;

SHOW TABLES

Query id: f403c327-5cdd-4c72-9915-5f70393d6b19

┌─name───┐
│ t_test │
└────────┘

1 rows in set. Elapsed: 0.003 sec.

11e7771e482c :) insert into t_test(id,name)values(1,'boonya');

INSERT INTO t_test (id, name) FORMAT Values

Query id: 886f8513-b925-4462-a039-a32228857767

Ok.

1 rows in set. Elapsed: 0.006 sec.

11e7771e482c :) select * from t_test

SELECT *
FROM t_test

Query id: 6e2ce514-5b6e-47d0-adec-4ca4d9d67fd9

┌─id─┬─name───┐
│  1 │ boonya │
└────┴────────┘

1 rows in set. Elapsed: 0.001 sec.

11e7771e482c :) insert into t_test(id,name)values(2,'xnn');

INSERT INTO t_test (id, name) FORMAT Values

Query id: d6ea947e-7650-4f9a-9f1d-16cad6a986e2

Ok.

1 rows in set. Elapsed: 0.001 sec.

11e7771e482c :) insert into t_test(id,name)values(3,'penglanjing');

INSERT INTO t_test (id, name) FORMAT Values

Query id: a238ed13-5fe2-4ec2-8655-3c0493750c2a

Ok.

1 rows in set. Elapsed: 0.001 sec.

11e7771e482c :) insert into t_test(id,name)values(4,'penglanting');

INSERT INTO t_test (id, name) FORMAT Values

Query id: e5f98e96-3c7b-43e2-935c-c1089aaab6b7

Ok.

1 rows in set. Elapsed: 0.002 sec.

11e7771e482c :) select * from t_test

SELECT *
FROM t_test

Query id: 89300ed3-6885-41f2-a8d4-5e8115aa1fb3

┌─id─┬─name───┐
│  1 │ boonya │
└────┴────────┘
┌─id─┬─name────────┐
│  3 │ penglanjing │
└────┴─────────────┘
┌─id─┬─name────────┐
│  4 │ penglanting │
└────┴─────────────┘
┌─id─┬─name─┐
│  2 │ xnn  │
└────┴──────┘

4 rows in set. Elapsed: 0.002 sec.

11e7771e482c :)

另附建表和插入数据示例：

CREATE DATABASE IF NOT EXISTS test;

CREATE TABLE test.user
(
    user_id UInt32,
    message String,
    timestamp DateTime,
    metric Float32
)
ENGINE = MergeTree()
PRIMARY KEY (user_id, timestamp);


INSERT INTO test.user (user_id, message, timestamp, metric) VALUES
    (101, 'Hello, ClickHouse!',                                 now(),       -1.0    ),
    (102, 'Insert a lot of rows per batch',                     yesterday(), 1.41421 ),
    (102, 'Sort your data based on your commonly-used queries', today(),     2.718   ),
    (101, 'Granules are the smallest chunks of data read',      now() + 5,   3.14159 );

posted on 2022-07-15 12:42 boonya 阅读(211) 评论(0) 编辑收藏举报