Articles by Shiv Iyer

About Shiv Iyer
Open Source Database Systems Engineer with a deep understanding of Optimizer Internals, Performance Engineering, Scalability and Data SRE. Shiv currently is the Founder, Investor, Board Member and CEO of multiple Database Systems Infrastructure Operations companies in the Transaction Processing Computing and ColumnStores ecosystem. He is also a frequent speaker in open source software conferences globally.
Website Facebook Twitter LinkedIn
Mastering Chained Joins In Clickhouse
ClickHouse Join

ClickHouse JOIN: Mastering Chained Joins

Shiv Iyer
Introduction Financial systems analytics demand sophisticated data manipulation, often involving multiple joins to extract valuable insights. In this guide, we will explore how to implement multiple joins, often referred to as chained joins, in ClickHouse, […]
Mastering Hash Joins In Clickhouse
ClickHouse Join

Hash Joins in ClickHouse: A Practical Guide

Shiv Iyer
Introduction : Hash Joins in ClickHouse  Hash Joins in ClickHouse are a powerful method for efficiently combining data from multiple tables. They fall under the category of “merge joins,” where ClickHouse takes advantage of sorted […]
Understanding Clickhouse Advanced Hash and Merge Joins
ClickHouse Performance

ClickHouse JOINs Explained: Advanced Hash and Merge Joins

Shiv Iyer
Introduction: ClickHouse Joins In the realm of data analytics, performance is often the key differentiator between success and stagnation. ClickHouse, an open-source columnar database management system, has gained popularity for its exceptional query performance, especially […]
Archival Store

Archiving Data to ClickHouse

Shiv Iyer
Building High Performance Lean Data Platforms  – Archiving Data to ClickHouse ClickHouse is a versatile database management system known for its real-time analytics capabilities. However, it offers more than just real-time analytics. ClickHouse can also […]