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

ClickHouse Partition Management: Attach, Drop, Move and Freeze

ChistaDATA Inc.

Introduction In ClickHouse, data is organized into tables, and each table is divided into one or more part/partitions. For detailed information about parts and partitions, please visit Part 1. In this part of the series, […]

ClickHouse Parts and Partitions: Part 1

ChistaDATA Inc.

Introduction In ClickHouse, a physical file on a disk that stores a portion of the table’s data is called a “part”. A “partition,” on the other hand, is a logical division of a table’s data […]

Streaming from MySQL to ClickHouse using Redpanda & KsqlDB

Streaming Data from MySQL to ClickHouse using Redpanda and KsqlDB

ChistaDATA Inc.

Introduction In a traditional way, data analysis is not quick and is not frequently performed. In the modern world, it is necessary to perform real time data analysis quickly and frequently to improve the business. […]

ClickHouse Query Profiler: Introduction to ChistaDATA Anansi

ChistaDATA Inc.

Introduction ChistaDATA Anansi is a log analyzing tool built for ClickHouse. It is a CLI tool written in Go. The reports generated by the profiler shed light on the different aspects of queries like execution […]

ClickHouse Release Notes December 2022 Version 22.12

ClickHouse December 2022 Release – v22.12

ChistaDATA Inc.

Introduction Every new release includes new features, enhancements, and numerous bug fixes, and the ChistaDATA team always stays on top of the latest releases. On December 15, 2022, ClickHouse version 22.12 was released, and this […]

Sneak Peek at ChistaDATA Cloud for ClickHouse

ChistaDATA Inc.

Introduction After months of hard work designing, developing, and testing our offering as ChistaDATA Cloud has reached an early preview stage. In this post, we’d like to give you a quick sense of what’s coming […]

Clickhouse Projection for Query Optimization

ClickHouse Performance: How to use Projections for Query Optimization

ChistaDATA Inc.

Introduction Among DBAs, there is much debate regarding the significance of database performance tuning. As we now understand, various types of data are what really power the business world. It should be operating very effectively […]

ClickHouse Docker Compose: Bind Mounts, Networking and Port Mapping

ChistaDATA Inc.

Introduction ClickHouse is an open-source columnar database meant for online analytical processing workloads. We have covered how to set up ClickHouse using Docker in this post. In this article, we will cover the following: Docker […]

ClickHouse MergeTree: Introduction to VersionedCollapsingMergeTree

ChistaDATA Inc.

Introduction The VersionedCollapsingMergeTree table engine is again based on MergeTree engine, and it adds more functionality on top of CollapsingMergeTree engine. You can read about CollapsingMergeTree engine and the collapsing rules here. CollapsingMergeTree engine requires […]

ClickHouse on Kubernetes: Running ClickHouse Cluster on Google Kubernetes Engine

ChistaDATA Inc.

Introduction Kubernetes orchestration simplifies many common operational concerns like scheduling, auto-scaling, and failover. Usually, databases that support replication, sharding, and auto-scaling are well-suited for Kubernetes. ClickHouse and Kubernetes can perform better together. At ChistaData, we […]