打开ClickHouse官网的Quick Start:https://clickhouse.com/#quick-start
选择自己的OS版本:
//使用以下命令可先判断机器是否支持ClickHouse安装
grep -q sse4_2 /proc/cpuinfo && echo "SSE 4.2 supported" || echo "SSE 4.2 not supported"
//安装ClickHouse
sudo yum install yum-utils
sudo rpm --import https://repo.clickhouse.com/CLICKHOUSE-KEY.GPG
sudo yum-config-manager --add-repo https://repo.clickhouse.com/rpm/clickhouse.repo
sudo yum install clickhouse-server clickhouse-client
//启动ClickHouse
sudo /etc/init.d/clickhouse-server start //启动服务端
clickhouse-client # or "clickhouse-client --password" if you set up a password. //启动客户端
clickhouse-client //启动客户端默认在localhost:9000
clickhouse-client --host=localhost --port=9000 -m //也可以自己指定,也可以在配置文件里指定
//具体在/etc/clickhouse-server/ 里的 config.xml文件 修改listen_host和port
//-m是指在数据表里写sql时可以将一条sql语句分行输入,否则只能讲一条sql语句完整输入
更详细安装内容:https://clickhouse.com/docs/en/getting-started/install/
//ClickHouse命令行简单建库、建表、查询语句
show databases;
select currentDatabase();
create databases people;
use people;
show tables;
create table user(id Int8,name String) engine=TinyLog;
insert into table user values (1,'zs'),(2.'ls'),(3,'zw');
select * from user;
select count(1) from user;
ClickHouse的目录信息:
/etc/clickhouse-server/
config.d config.xml users.d users.xml //config.xml包含的是clickhouse全局的配置,users.xml包含用户相关的配置
/var/lib/clickhouse/
//里面有许多文件,主要关注 data 和 metadata
//data里面包含clickhouse的数据库
//metadata存放对应库表的元数据信息,创建了people数据库,就会有people people.sql
/var/log/clickhouse-server/
clickhouse-server.err.log clickhouse-server.log //clickhouse-server的日志文件