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

Compression Algorithms and Codecs in ClickHouse

ChistaDATA Inc.

Introduction The amount of data stored in databases is increasing day by day. This increases the cost required for data storage and network access. Compression techniques are a commonly used method to save storage space […]

How to Ingest Data from a Kafka Topic in ClickHouse

ChistaDATA Inc.

Introduction Apache Kafka is a distributed event streaming platform developed by Apache Software Foundation. Visit the official page before proceeding for a detailed introduction to the basics of Kafka. The installation instructions are available here. ClickHouse […]

ClickHouse MergeTree

ClickHouse MergeTree: Introduction to ClickHouse Storage Engine Types

ChistaDATA Inc.

Introduction Data is a collection of information that can be used for many different purposes, including big-volume data analysis, external data integration, and many more in ClickHouse. Broadly, engines play a key role in these […]

High Availability (HA) and Replication in ClickHouse

ChistaDATA Inc.

Introduction Is 90% availability good? Why is high availability important? What does that mean for a business in plain terms? Let’s dive into them. What is High Availability (HA)? Business critical databases require minimal downtime […]

ClickHouse August 2022 Release – v22.8

ChistaDATA Inc.

Introduction ClickHouse version 22.08 (August 2022) was released on August 18, 2022. This version includes 12 new features, 12 performance improvements, +40 other improvements, and over 45 bug fixes. For more information, please visit the […]

ClickHouse Performance: Comprehensive Guide to SQL Engineering Best Practices

ClickHouse SQL Engineering: A Complete Guide to Best Practices

ChistaDATA Inc.

Introduction SQL is the computer language used to communicate with Databases. It is also an important key factor for database performance. If the SQL query is not designed effectively, it can impact performance negatively. In […]

ClickHouse MergeTree: Deletes and Updates with CollapsingMergeTree

ChistaDATA Inc.

Introduction: CollapsingMergeTree Deletion and updating the records are common on transactional databases. ClickHouse supports deletes and updates in MergeTree table engine via the ALTER TABLE … statement. They are also known as Mutations which happen […]

ChistaDATA Inc.

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

Articles by ChistaDATA Inc.

Compression Algorithms and Codecs in ClickHouse

How to Ingest Data from a Kafka Topic in ClickHouse

ClickHouse MergeTree: Introduction to ClickHouse Storage Engine Types

High Availability (HA) and Replication in ClickHouse

ClickHouse August 2022 Release – v22.8

ClickHouse SQL Engineering: A Complete Guide to Best Practices

ClickHouse MergeTree: Deletes and Updates with CollapsingMergeTree

Compression Techniques in Columnar Databases

IDE (QtCreator) Setup for ClickHouse Development

Comparing ClickHouse vs RocksDB for Real-time Analytics