Thursday, March 12, 2026

Getting started with Clickhouse

Download Oracle's VirtualBox

https://www.virtualbox.org/


Alternatively, download

VMware Workdstation Pro, however, licensing state can be unstable throughout the

time. 



Download Ubuntu 

https://ubuntu.com/download/desktop


Install the Ubuntu ISO

From within the Ubuntu OS Download ClickHouse

https://clickhouse.com/support/platforms 


I am using the Quick Install Guide

https://clickhouse.com/docs/install/quick-install-curl 


How to ingest data into Clickhouse 

https://clickhouse.com/docs/guides/inserting-data  OR use the following but it takes awhile for 24 million rows of data insertion. 


CREATE TABLE hackernews ENGINE = MergeTree ORDER BY tuple() AS
SELECT * FROM
url('https://datasets-documentation.s3.eu-west-3.amazonaws.com/hackernews/hacknernews.csv.gz',
'CSVWithNames'); Learning Resources Register Clickhouse Learning
https://learn.clickhouse.com/ https://clickhouse.com/docs/academic_overview



Other resources

Learning Resources Register Clickhouse Learning

https://learn.clickhouse.com

https://clickhouse.com/docs/academic_overview


Playgrounds

https://play.clickhouse.com/

https://sql.clickhouse.com/


Common directories

config files

/etc/clickhouse-server/config.d/backup_disk.xml

/etc/clickhouse-server/config.d/data-paths.xml

/etc/clickhouse-server/config.d/listen.xml

/etc/clickhouse-server/config.d/logger.xml

/etc/clickhouse-server/config.d/openssl.xml

/etc/clickhouse-server/config.d/user-directories.xml

/etc/clickhouse-server/users.d/default-password.xml

/etc/clickhouse-server/config.xml


logs

/var/log/clickhouse-server/clickhouse-server.log

/var/log/clickhouse-server/clickhouse-server.err.log


No comments:

Post a Comment

Issue trying to back up the clickhouse database

While trying to issue a backup database statement and receiving the following error. Code: 627. DB::Exception: Received from localhost:9000....