Clickhouse

Deploy

Clone the repository and change the directory to the cloned one.

docker-compose up -d

Migration

Install clickhouse cli

curl https://clickhouse.com/ | sh

Connecting server

./clickhouse server

Connecting client

./clickhouse client

Export Data

 ./clickhouse client --host 127.0.0.1 --secure --password 123456 --port 9000 --query "SELECT * from table" --format FormatName > result.txt

--secure for ssl

Import Data

./clickhouse client --host 127.0.0.1 --secure --password 123456 --port 9000 --query "insert into table format FormatName" < result.txt

Reference links

Name	Description	Link
Formats	Input and output formats	https://clickhouse.com/docs/en/interfaces/formats
Install	Installation	https://clickhouse.com/docs/en/install
Export	Export data	https://clickhouse.com/docs/knowledgebase/file-export
Import	Import data	https://clickhouse.com/docs/en/integrations/data-formats/csv-tsv