Explore ClickHouse Insights on ChistaDATA's Blog

Long integer query optimization in ClickHouse

Optimizing Long Integer Queries in ClickHouse: Strategies for High-Speed Data Analysis

Introduction – Long Integer Queries Navigating the terrain of querying long integer data (64-bit integers) in ClickHouse is a journey of optimising performance through strategic choices in data types, leveraging indexing, and fine-tuning query operations. […]

RocksDB + ClickHouse for High-Velocity Workloads

Enhancing Data Ingestion: Integrating RocksDB with ClickHouse for High-Velocity Workloads

Shiv Iyer

Introduction: RocksDB ClickHouse Integration Integrating RocksDB with ClickHouse for high-velocity, high-volume data ingestion leverages the strengths of both systems to address specific challenges. RocksDB, a high-performance, embedded key-value store optimized for fast storage on flash […]

Optimizing Performance: Inside ClickHouse’s Thread Pool Management

Shiv Iyer

Introduction: Thread Pool Management ClickHouse manages its thread pool operations with a keen focus on maximizing performance and efficiently handling concurrent queries and tasks. The internal handling of thread pools in ClickHouse is designed to […]

Migrating From Google BigQuery to ChistaDATA Cloud for ClickHouse: Part 1

ChistaDATA Inc.

Introduction BigQuery is Google‘s fully managed, serverless data warehouse that enables scalable analysis over petabytes of data. – Wikipedia Google BigQuery has been around for over a decade and offers serverless / fully managed solutions for data warehouse/ analytical […]

ClickHouse Winter 2024 Release – v24.2

ChistaDATA Inc.

Introduction: ClickHouse Winter 2024 Release – v24.2 Each new release includes new features, improvements, and numerous bug fixes, and the ChistaDATA team is always on top of the latest releases. On 29th February 2024, ClickHouse […]

Workload Scheduling In ClickHouse

ChistaDATA Inc.

Introduction Workload scheduling is a sophisticated method to efficiently manage resources among various tasks in ClickHouse. This technique is crucial for balancing different workloads, such as production and development tasks, ensuring optimal resource allocation and […]