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:
- Columnar Storage.
- Vectorized Execution.
- Data Compression.
- Skip Indexes.
- Multi-threaded by default.
- Merge Tree Engine.
Key architectural concepts:
a) MergeTree Tables.
b) Distributed Tables.
c) Materialized Views.
d) Time To Live(TTL).
Managed V/S Unmanaged Tables in Databricks
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.
Basic Bash Scripts
Basic Bash Commands
Python Concepts – 01
Azure Services commonly used for Data Engineering
AWS Services commonly used for Data Engineering
GCP Services commonly used for Data Engineering
