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
ClickHouse vs Hadoop for Real-time Analytics
ClickHouse Hadoop

Limitations of Hadoop in Real-time Analytics

Shiv Iyer
Introduction Hadoop is a powerful, open-source ecosystem for storing and processing large datasets, but it is not well-suited for real-time analytics. Hadoop’s limitations in Real-time Analytics Here are a few reasons why Hadoop is not […]
No Picture
ClickHouse Memory

Decoding Memory Management in ClickHouse

Shiv Iyer
Introduction ClickHouse uses a memory management system to control the allocation and deallocation of memory resources. The main components of the memory management system are: Memory Pool: ClickHouse uses a memory pool to manage the […]
No Picture
ClickHouse Performance

How does the ClickHouse Query Parser work?

Shiv Iyer
Introduction ClickHouse uses a SQL parser to process SQL statements and convert them into a query execution plan. The parser is responsible for validating the syntactic and semantic correctness of SQL statements, and for transforming […]