Install ClickHouse on Centos 8

• Install ClickHouse on Centos 8

Install ClickHouse on Centos 8

add repo

sudo dnf install -y yum-utils

sudo yum-config-manager --add-repo https://packages.clickhouse.com/rpm/clickhouse.repo

install

sudo dnf install -y clickhouse-server clickhouse-client

start & enable

sudo systemctl enable --now clickhouse-server

open firewall (optional)

sudo firewall-cmd --permanent --add-port=8123/tcp
sudo firewall-cmd --permanent --add-port=9000/tcp
sudo firewall-cmd --reload

Remember the top most <listen_host>0.0.0.0</listen_host>

test locally

clickhouse-client -q "SELECT version();"

Configure Clickhouse Server Config file

sudo nano /etc/clickhouse-server/config.xml

Uncommet below this statement :

<listen_host>0.0.0.0</listen_host>

Verify ClickHouse from DBeaver

Run a test query:

SELECT version();

CREATE DATABASE IF NOT EXISTS demo ON CLUSTER default;

CREATE TABLE demo.test ON CLUSTER default ( ts DateTime, name String ) ENGINE = ReplicatedMergeTree() ORDER BY ts;

INSERT INTO demo.test (ts, name) VALUES (now(), 'Cluster Test 5');

CREATE TABLE demo.test_distributed ON CLUSTER default AS demo.test ENGINE = Distributed('default', 'demo', 'test', rand());

select * from demo.test_distributed;

SELECT hostName(), ts, name FROM clusterAllReplicas('default', demo.test);