Articles by ChistaDATA Inc.

About ChistaDATA Inc.

We are an full-stack ClickHouse infrastructure operations Consulting, Support and Managed Services provider with core expertise in performance, scalability and data SRE. Based out of California, Our consulting and support engineering team operates out of San Francisco, Vancouver, London, Germany, Russia, Ukraine, Australia, Singapore and India to deliver 24*7 enterprise-class consultative support and managed services. We operate very closely with some of the largest and planet-scale internet properties like PayPal, Garmin, Honda cars IoT project, Viacom, National Geographic, Nike, Morgan Stanley, American Express Travel, VISA, Netflix, PRADA, Blue Dart, Carlsberg, Sony, Unilever etc

Database Operations for Real-time Analytics

ChistaDATA Inc.

Introduction: Database Operations for Real-time Analytics Data is an important resource that needs to be used to make a difference in the business world make correct and consistent decisions and increase success today, as it […]

Configuring Skipping Indexes in ClickHouse

How to Configure Data Skipping Indexes in ClickHouse for Query Performance

ChistaDATA Inc.

Introduction to Data Skipping Indexes When working on ClickHouse, many different factors can affect its performance of Clickhouse. One of the most critical elements is that ClickHouse determines whether it will use a primary key […]

Aggregate Functions via ClickHouse

ChistaDATA Inc.

Introduction Functions that arrive at the resultant value by calculating on a set of values are called aggregation functions. In ClickHouse, aggregate functions work in the normal way as expected by database expert. In this […]

ClickHouse June 2022 Release – v22.6

ChistaDATA Inc.

Introduction This article will introduce the new features defined in the new version of ClickHouse, version 22.6. For more information please visit official ClickHouse docs here. Download the ClickHouse 22.6 release here. ClickHouse Release 22.6 […]

ClickHouse JSON Data Explained

ChistaDATA Inc.

Introduction : ClickHouse JSON JSON refers to Javascript Object Notation. It is a popular text data format used to exchange data on modern web and mobile applications. It is based on a subset of the […]

Bloom Filter in ClickHouse: How to Implement It for Query Performance

ChistaDATA Inc.

Introduction: Bloom Filter in ClickHouse A Bloom filter is a data structure that tells the user whether a particular item is part of a set. Although it cannot definitively tell if an item is in […]

ClickHouse May 2022 Release – v22.5

ChistaDATA Inc.

Introduction This article will introduce the new features defined in the new version of ClickHouse, version 22.5. You can reach to the new ClickHouse release here. Key features & improvements ClickHouse has added new features […]

Reflections from PerconaLive 2022 Austin, TX

ChistaDATA Inc.

PerconaLive As a long-term Perconalive veteran, the most recent Perconalive was more than an Open Source Database conference. It meant to be reunited with thought leaders of open source databases; it meant to be there, […]

Swiss PGDay 2022

ChistaDATA Inc.

The Swiss conference on PostgreSQL Swiss PGDay 2022 Friday, July 1, 2022 OST Eastern Switzerland University of Applied Sciences, Campus Rapperswil (Switzerland) Covid-19: No pandemic-related restrictions are expected on the Rapperswil campus. Nevertheless, we appeal […]

How to Recover ClickHouse After ZooKeeper Metadata is Corrupted?

ClickHouse Troubleshooting: How to Restore/Recover ClickHouse after ZooKeeper Metadata is Corrupted/Lost

ChistaDATA Inc.

Introduction When you are building a highly available ClickHouse Infrastrstucture for scale and performance we use ZooKeeper for ClickHouse Replication Management and Operations with ReplicatedMergeTree table engine. You can expect ZooKeeper to face data loss […]