clickhouseInstall latest Clickhouse server on Ubuntu 22.04

apt install -y apt-transport-https ca-certificates dirmngr
apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv E0C56BD4
echo "deb https://repo.clickhouse.com/deb/stable/ main/" | sudo tee /etc/apt/sources.list.d/clickhouse.list
apt update && apt install -y clickhouse-server clickhouse-client
clickhouse startctrl + cgithub

`apt install` installs specified package on Ubuntu	`apt-key adv` sign Clickhouse official repo
`clickhouse-server` Clickhouse server package	`clickhouse-client` CLI client
`deb https://repo.clickhouse.com/deb/stable/ main/` Add official Clickhouse repo to apt repositories list	`clickhouse start` start Clickhouse server

More of Clickhouse

Convert array to rows
Get total database size
How to execute SQL query from a file
How to restart Clickhouse server
List all tables from all database
Using variables in queries
Select where date column is between dates
Select countIf usage example
Get table size
Select sumIf query example

See more codes...