Introduction

Column-oriented database management system.

• For OLAP (Online Analytical Processing) workloads.
• Only suitable for querying large datasets.
• Not designed for row-level mutations.

Install ClickHouse (docker)

Local docker:

• 8123 → HTTP interface
• 9000 → native client

docker run -d \
  --name clickhouse \
  -p 8123:8123 \
  -p 9000:9000 \
  clickhouse/clickhouse-server

Connect:

dockerexec -it clickhouse clickhouse-client

Column-based

Data is stored column by column.

• Insanely fast in getting the data from a column
  • For row-based, it need to read every column of the rows