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