Tag: olap

Posts tagged "olap"

ClickHouse® Architecture Basics: Nodes, Shards, and Replicas

Learn the fundamentals of ClickHouse® architecture, including nodes, shards, and replicas. Understand how distributed clusters scale storage, improve performanc

Sanjeev Kumar GJune 12, 202610 min read

Basic Data Aggregation in ClickHouse®

Learn the fundamentals of data aggregation in ClickHouse®. Explore aggregate functions, GROUP BY, time-based aggregations, ROLLUP, CUBE, and performance optimiz

Sanjeev Kumar GJune 10, 20268 min read

Your First ClickHouse® Query: A Step-by-Step Tutorial

Learn how to write your first ClickHouse® query with this beginner-friendly step-by-step tutorial. Create tables, insert data, filter results, and perform aggre

Sanjeev Kumar GJune 5, 20267 min read

ClickHouse® vs PostgreSQL: When to Use Which?

ClickHouse vs PostgreSQL - what's the real difference? Learn how each database works, when to use which, and its performance trade-offs.

Reshma MJune 4, 20268 min read

When Should High-Cardinality Columns Come First in ClickHouse ORDER BY?

Learn when high-cardinality columns improve ClickHouse ORDER BY performance and how to choose correctly.

Mohamed Hussain SFebruary 19, 20265 min read

Deep Dive into the Native JSON Data Type in ClickHouse®

A deep dive into ClickHouse®’s native JSON type: binary storage, lazy parsing, performance trade-offs, and real-world use cases.

Sanjeev Kumar GJanuary 27, 20265 min read

Why Modern Companies Need OLAP Systems Like ClickHouse

Discover why today’s companies rely on OLAP systems like ClickHouse for real-time analytics, faster queries, and scalable data processing.

Reshma MDecember 3, 20255 min read