1. 安装 curl 系统包
#yum install -y curl
2. 安装 clickhouse repositories
#curl -s https://packagecloud.io/install/repositories/altinity/clickhouse/script.rpm.sh |bash
3. 查询 clickhouse 包
- #yum list clickhouse*
- Loaded plugins: fastestmirror
- Loading mirror speeds from cached hostfile
- base: mirror.bit.edu.cn
- extras: mirror.bit.edu.cn
- updates: mirror.bit.edu.cn
- Available Packages
- clickhouse-client.x86_64 1.1.54343-1.el7 Altinity_clickhouse
- clickhouse-compressor.x86_64 1.1.54336-3.el7 Altinity_clickhouse
- clickhouse-debuginfo.x86_64 1.1.54343-1.el7 Altinity_clickhouse
- clickhouse-server.x86_64 1.1.54343-1.el7 Altinity_clickhouse
- clickhouse-server-common.x86_64 1.1.54343-1.el7 Altinity_clickhouse
- clickhouse-test.x86_64 1.1.54343-1.el7 Altinity_clickhouse
4. 安装 clickhouse 包
- #yum install -y clickhouse*
- #yum list installed clickhouse*
- Loaded plugins: fastestmirror
- Loading mirror speeds from cached hostfile
- base: mirror.bit.edu.cn
- extras: mirror.bit.edu.cn
- updates: mirror.bit.edu.cn
- Installed Packages
- clickhouse-client.x86_64 1.1.54343-1.el7 @Altinity_clickhouse
- clickhouse-debuginfo.x86_64 1.1.54343-1.el7 @Altinity_clickhouse
- clickhouse-server.x86_64 1.1.54343-1.el7 @Altinity_clickhouse
- clickhouse-server-common.x86_64 1.1.54343-1.el7 @Altinity_clickhouse
- clickhouse-test.x86_64 1.1.54343-1.el7 @Altinity_clickhouse
5. 启动数据库
- #/etc/init.d/clickhouse-server restart
- Start clickhouse-server service: Path to data directory in /etc/clickhouse-server/config.xml: /var/lib/clickhouse/
- DONE
6. 连接数据库
- #clickhouse-client
- ClickHouse client version 1.1.54343.
- Connecting to localhost:9000.
- Connected to ClickHouse server version 1.1.54343.
- :)
- :)
- :) create database testdb;
- CREATE DATABASE testdb
- Ok.
- 0 rows in set. Elapsed: 0.003 sec.
- :)
- :) use testdb
- USE testdb
- Ok.
- 0 rows in set. Elapsed: 0.001 sec.
- :)
- :) CREATE TABLE arrays_test (s String, arr Array(UInt8)) ENGINE = Memory;
- CREATE TABLE arrays_test
- (
- s String,
- arr Array(UInt8)
- )
- ENGINE = Memory
- Ok.
- 0 rows in set. Elapsed: 0.003 sec.
- :)
- :) INSERT INTO arrays_test VALUES (Hello, [1,2]), (World, [3,4,5]), (Goodbye, [])
- INSERT INTO arrays_test VALUES
- Ok.
- 3 rows in set. Elapsed: 0.060 sec.
- :)
- :) SELECT * FROM arrays_test
- SELECT *
- FROM arrays_test
- sarr
- Hello [1,2]
- World [3,4,5]
- Goodbye []
- 3 rows in set. Elapsed: 0.003 sec.
- :)
- :) SELECT s, arr FROM arrays_test ARRAY JOIN arr
- SELECT
- s,
- arr
- FROM arrays_test
- ARRAY JOIN arr
- sarr
- Hello 1
- Hello 2
- World 3
- World 4
- World 5
- 5 rows in set. Elapsed: 0.003 sec.
- :)
来源: http://www.bubuko.com/infodetail-2496288.html