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 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 […]

Running ClickHouse with Docker: Part 2

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 […]

ChistaDATA Inc.

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

Articles by ChistaDATA Inc.

ClickHouse Query Profiler: Introduction to ChistaDATA Anansi

ClickHouse December 2022 Release – v22.12

Sneak Peek at ChistaDATA Cloud for ClickHouse

ClickHouse Performance: How to use Projections for Query Optimization

Running ClickHouse with Docker: Part 2

ClickHouse MergeTree: Introduction to VersionedCollapsingMergeTree

ClickHouse on Kubernetes: Running ClickHouse Cluster on Google Kubernetes Engine

Getting Started with ClickHouse using clickhouse-local

ClickHouse Performance: Decoding Query Execution Plan with EXPLAIN

ClickHouse November 2022 Release – Version 22.11