Posts

Posted on

ClickHouse

ClickHouse is an open-source, columnar, OLAP(Online Analytical Processing) database designed for extremely fast analytical queries  on large data volumes.

Popular fields deployed in: ad-tech, IoT, BI and more.

ClickHouse is fast because:

  1. Columnar Storage.
  2. Vectorized Execution.
  3. Data Compression.
  4. Skip Indexes.
  5. Multi-threaded by default.
  6. Merge Tree Engine.

Key architectural concepts:

a) MergeTree Tables.

b) Distributed Tables.

c) Materialized Views.

d) Time To Live(TTL).

ClickHouse

Posted on

SUN is shining

Wishing everyone a Happy Makara Sankranthi.

Bengaluru is experiencing better sunshine today, the temperature is warmer compared to chilling last few days.

Expressing amazement and joy to the precision engineering of nature, where sun bathes Gavi Gangadhareshwara on this special day.

I pray for a better harvest and preservation of the yield to farmers.

A special thanks to Mr. Sun who is the greatest source of energy for the earth and it’s inhabitants.

Savour the sweets and experience the bright side.