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

Streaming Data from PostgreSQL to ClickHouse using Kafka and Debezium: Part 1

ChistaDATA Inc.

Introduction A quick calculation of analytical business data using metrics for modeling, planning, or forecasting is possible with OLAP only. Also a lot of business applications for reporting, simulation models, information-to-knowledge transfers, and trend and […]

Overview of System Tables In ClickHouse

ChistaDATA Inc.

Introduction ClickHouse is an open-source columnar database management system designed for handling large volumes of data. It is known for its high performance, scalability, and flexibility. One of the key features of ClickHouse is its […]

Get Started with ChistaDATA Cloud for ClickHouse: Part 1

ChistaDATA Inc.

Introduction Exciting news for all data enthusiasts! We are thrilled to announce that our ChistaDATA DBaaS platform for ClickHouse is now generally available, providing a powerful and reliable solution for managing and analyzing large volumes […]

ClickHouse MergeTree: Introduction to ReplicatedMergeTree

ChistaDATA Inc.

Introduction ClickHouse has MergeTree family of engines and data replication can be achieved through the replicated version of the MergeTree family engines. This replication works on an individual table level. ClickHouse has recently added support […]

Overview of information_schema Tables In Clickhouse

ChistaDATA Inc.

Introduction ClickHouse is an open-source columnar database management system that is designed for real-time data processing and analytics. One of the unique features of ClickHouse is its use of the information_schema database, which provides a […]

Streaming ClickHouse Data to Kafka

ChistaDATA Inc.

Introduction ClickHouse has an inbuilt Kafka table engine which is commonly used to read streaming messages from Apache Kafka and store it in ClickHouse. This is one of the important and widely used features of […]

Benchmarking ClickHouse using the clickhouse-benchmark Tool

ChistaDATA Inc.

Introduction ClickHouse is a popular open-source analytical database management system that is designed to handle massive amounts of data. It has been adopted by many companies for its excellent performance, low latency, and scalability. However, […]

ClickHouse Monitoring: Configuring ClickHouse Server Logs in JSON Format

ChistaDATA Inc.

Introduction ClickHouse is a fast, open-source column-oriented database used to analyze large amounts of data. One of the key features of ClickHouse is its support for logging server activity in JSON format, which allows easy […]

ClickHouse January 2023 Release – Version 23.1

ChistaDATA Inc.

Introduction ClickHouse team is back with a new release for the month of January. Being the first release of the year, it has lot of exciting features, enhancements, and speed improvements. This release has 17 […]

Implementing Data Compression in ClickHouse with COMPRESS Function

How to implement Data Compression in ClickHouse with COMPRESS Function

ChistaDATA Inc.

Introduction ClickHouse is an open-source column-oriented database management system developed by Yandex. One of the critical features of ClickHouse is its ability to compress data in order to save storage space and increase query performance. […]