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
┌─s───────┬─arr─────┐ │ 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
┌─s─────┬─arr─┐ │ Hello │ 1 │ │ Hello │ 2 │ │ World │ 3 │ │ World │ 4 │ │ World │ 5 │ └───────┴─────┘
5 rows in set. Elapsed: 0.003 sec.
:)