环境说明
操作系统：Ubuntu 16.04.4
ip：192.168.18.61
安装
sudo apt-get update
sudo apt-get install apt-transport-https ca-certificates dirmngr
sudo apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv E0C56BD4
echo "deb https://repo.clickhouse.tech/deb/stable/ main/" | sudo tee \ /etc/apt/sources.list.d/clickhouse.list
sudo apt-get update
sudo apt-get install -y clickhouse-server clickhouse-client
sudo service clickhouse-server start
包含软件包：
- clickhouse-client 包：包含clickhouse-client客户端，它是交互式ClickHouse控制台客户端。
- clickhouse-common 包：包含一个ClickHouse可执行文件。
- clickhouse-server 包：包含要作为服务端运行的ClickHouse配置文件。
服务器配置文件位于/etc/clickhouse-server/config.xml
By default, it connects to localhost:9000 on behalf of the user default without a password. It can also be used to connect to a remote server using --host argument.
测试
客户端连接
clickhouse-client -password 123456
创建database
clickhouse-client --password 123456 --query "CREATE DATABASE IF NOT EXISTS tutorial"
查看数据库
clickhouse-client --password 123456 --query "show databases"
允许远程连接
vi /etc/clickhouse-server/config.xml
<listen_host>::</listen_host>
