ClickHouse DBA

Compatibility of the CASE expression in ClickHouse

ClickHouse, an open-source columnar database management system, offers several ways to write case expressions. Case expressions perform conditional branching and...

Explain ClickHouse Data Skipping Index with use case

ClickHouse’s Data Skipping Index is a feature that allows for efficient skipping of irrelevant data blocks during query execution, resulting...

Set TTL for System Tables for Storage Optimisation and Managing data retention

The following query identifies the largest tables in the system schema. The results display the table name, compressed size, uncompressed...

ChistaDATA – ClickHouse Shard Config Generator

We developed a shard config xml generator for ClickHouse. All you have to do download and run the python script...

Integrating MongoDB with ClickHouse using Docker

This guide will walk you through integrating MongoDB with ClickHouse using Docker containers. This integration allows you to perform real-time...