Shiv Iyer, Author at ChistaDATA Inc.

Understanding ClickHouse MergeTree: Data Organization, Merging, Replication, and Mutations Explained

Understanding ClickHouse MergeTree: Data Organization, Merging, Replication, and Mutations Explained ClickHouse is renowned for its high-performance analytics and its ability to efficiently handle massive amounts of data. At the core of ClickHouse’s data storage and […]

Delta Updates in OLAP Databases: Why They Hurt Performance

Shiv Iyer

Why Delta Updates Are Not Recommended in OLAP Databases: A Performance and Efficiency Perspective Delta Updates in OLAP (Online Analytical Processing) databases are not recommended due to the fundamental design and architecture of these systems, […]

ClickHouse Search: Manticore Full Text Search with Plain Index

Mastering User Management in ClickHouse: A Complete Guide to Authentication, Authorization, and Future Security Enhancements

Shiv Iyer

User Management in ClickHouse: A Comprehensive Guide Introduction User management is a critical aspect of any analytical application, as it ensures secure access to data while maintaining flexibility for various users. In ClickHouse, user management […]

ClickHouse Parquet Ingestion via Kafka: A Step-by-Step Guide

Shiv Iyer

Unlock the Power of Data: Seamlessly Integrate Parquet File Ingestion into ClickHouse with Kafka – Your Ultimate Step-by-Step Guide to Optimized Performance! ClickHouse Parquet Ingestion enables a seamless, high-performance workflow for moving data from distributed […]

ClickHouse Data Compression Techniques for Time-series Datasets

Optimizing Non-SARGable Predicates in ClickHouse for Improved Query Performance

Shiv Iyer

ClickHouse Query Optimization Non-SARGable (Search ARGument ABLE) predicates are conditions in SQL queries that prevent the database engine from using indexes efficiently, leading to full table scans and degraded query performance. Implementing and handling Non-SARGable […]

Tuning ClickHouse for High-Velocity Data Ingestion in Distributed Tables

ClickHouse S3 Tiered Storage for Data Archival and Compliance

Shiv Iyer

ClickHouse S3 Archival is a common strategy for handling large volumes of data efficiently, particularly for compliance purposes where data must be retained but is queried infrequently. Using tiered storage like S3 for archiving data […]

When to Avoid Indexing in ClickHouse for Optimal Performance

Implementing Custom Access Policies in ClickHouse: A Comprehensive Guide

Shiv Iyer

Custom Access Policies in ClickHouse Implementing access policies in ClickHouse similar to SQL Server’s Purview Access Policies requires combining ClickHouse’s built-in access control mechanisms with additional scripting and possibly external tools. ClickHouse does not have […]

ClickHouse Backup Toolkit: An Oracle RMAN-Like Approach

Shiv Iyer

ClickHouse Backup Toolkit Implementing a comprehensive backup and recovery toolkit for ClickHouse is essential to ensure data integrity, consistency, and reliability, forming the core of ClickHouse Data Reliability Engineering. While ClickHouse lacks a built-in tool […]

ClickHouse Redo Operations for Data Reliability

ClickHouse Data Purging: Strategies, Use Cases and Implementation

Shiv Iyer

Clickhouse Data Purging Efficiently purging data from ClickHouse is crucial for maintaining performance and managing storage costs, especially when dealing with large, real-life datasets. Here are some detailed strategies, complete with real-life data sets and […]

Troubleshooting High CPU Usage in ClickHouse

Securing ClickHouse Data at Rest: A Guide to Implementing Filesystem-Level Encryption

Shiv Iyer

ClickHouse Data at Rest ClickHouse does not directly support Transparent Data Encryption (TDE) in the same way that some other database systems do, such as Oracle or SQL Server, which provide built-in TDE capabilities to […]

ChistaDATA Inc.

Enterprise-class 24*7 ClickHouse Consultative Support and Managed Services

Articles by Shiv Iyer

Understanding ClickHouse MergeTree: Data Organization, Merging, Replication, and Mutations Explained

Delta Updates in OLAP Databases: Why They Hurt Performance

Mastering User Management in ClickHouse: A Complete Guide to Authentication, Authorization, and Future Security Enhancements

ClickHouse Parquet Ingestion via Kafka: A Step-by-Step Guide

Optimizing Non-SARGable Predicates in ClickHouse for Improved Query Performance

ClickHouse S3 Tiered Storage for Data Archival and Compliance

Implementing Custom Access Policies in ClickHouse: A Comprehensive Guide

ClickHouse Backup Toolkit: An Oracle RMAN-Like Approach

ClickHouse Data Purging: Strategies, Use Cases and Implementation

Securing ClickHouse Data at Rest: A Guide to Implementing Filesystem-Level Encryption