ChistaDATA Inc.

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

  • ChistaDATA
    • Columnar Stores vs. ROW-Based Databases
    • Vectorized Query
    • High Performance Analytics
    • Digital Transformation
    • Data Warehousing
  • ChistaDATA Server
    • Real-Time Analytics
      • Hadoop to ClickHouse
      • Amazon RedShift to ClickHouse
    • Data Archiving
    • ClickHouse Unveiled
    • ClickHouse Consulting
      • ClickHouse Performance Audit
        • Pre- Engagement Questionnaire
    • Online Ticketing System
  • Support
    • Data Analytics
    • Data Warehousing
    • ChistaDATA Analytics Support
    • Gen AI
    • Online Ticketing System
  • Managed Services
    • Data Strategy
    • Why engage ChistaDATA?
    • ClickHouse Managed Services
    • ClickHouse Performance Tuning
    • DBaaS Optimization
    • Data SRE
    • Online Ticketing System
  • Data Science
  • ChistaDATA Fabric
    • Data Archiving
    • ChistaDATA ColumnStore
  • Blog
    • Shiv Iyer Talks
    • ChistaDATA Blog
  • Careers
  • Contact
  • Twitter
  • Facebook
  • LinkedIn
    • Shiv Iyer
  • GitHub
    • @ShivIyer
  • Medium
HomeAuthorsChistaDATA Inc.

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
Website Facebook Twitter LinkedIn
Streaming from MySQL to ClickHouse using Redpanda & KsqlDB
ClickHouse Streaming

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
ClickHouse Query Profiler

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
Release Notes

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 Cloud

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

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
Docker

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
ClickHouse MergeTree

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

No Picture
ClickHouse Kubernetes

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

Getting started with ClickHouse using clickhouse-local
Getting Started

Getting Started with ClickHouse using clickhouse-local

ChistaDATA Inc.

Introduction Would you like to run ClickHouse queries without a server or attached storage? If your answer is yes, you can prefer clickhouse-local. We want to introduce you to clickhouse-local. It is all about SQL […]

ClickHouse Performance: Decoding Query Execution Plan with EXPLAIN
ClickHouse Explain

ClickHouse Performance: Decoding Query Execution Plan with EXPLAIN

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

Posts pagination

« 1 … 10 11 12 … 17 »

ChistaDATA is committed to open source software and building high performance ColumnStores

In the spirit of freedom, independence and innovation. ChistaDATA Corporation is not affiliated with ClickHouse Corporation 

Tell us how we can help!

Loading

Search ChistaDATA Website

★READ THIS WARNING★

* Everything changes over time – Our blogs/posts and comments changes over time, That’s how it should be! Whatever we comment from ChistaDATA Inc. Teams (including Shiv Iyer) and other stakeholders or guest bloggers posted here are never permanent, These things worked for us. But, there is no guarantee they will work for you too, When using the recommendations from ChistaDATA or MinervaDB or MinervaSQL or any other online resources / Google,  You must test the advice before applying them to your production systems, and always invest for a robust Database DR solution, Thank you for understanding. 

Recent Posts from ChistaDATA

  • Avoiding ClickHouse Fan Traps : A Technical Guide for High-Performance Analytics
  • Open Source Data Warehousing and Analytics
  • Implementing Data Level Security on ClickHouse: Complete Technical Guide
  • ClickHouse ReplacingMergeTree Explained
  • Building Fast Data Loops in ClickHouse®

☎ TOLL FREE PHONE (24*7)

(844)395-5717

🚩 ChistaDATA Inc. FAX

+1 (209) 314-2364

CORPORATE ADDRESS: HOUSTON

ChistaDATA Inc.,
1321 Upland Dr. PMB 19322, Houston,
TX, 77043, US

CORPORATE ADDRESS: CALIFORNIA

ChistaDATA Inc.
440 N BARRANCA AVE #9718 COVINA,
CA 91723

CORPORATE ADDRESS: NEW CASTLE, DELAWARE

ChistaDATA Inc.,
256 Chapman Road STE 105-4,
Newark, New Castle 19702,
Delaware

CORPORATE ADDRESS: DELAWARE

ChistaDATA Inc.,
PO Box 2093 PHILADELPHIA PIKE #3339
CLAYMONT, DE 19703

HOW CAN WE HELP?

We are committed to building Optimal, Scalable, Highly Available, Reliable, Fault-Tolerant and Secured Database Infrastructure Operations for WebScale to our customers globally

PostgreSQL is a registered trademark of the PostgreSQL Community Association. ClickHouse is a registered trademark of ClickHouse, Inc. MongoDB is a registered trademark of MongoDB, Inc. Couchbase is a registered trademark of Couchbase, Inc. Redis is a registered trademark of Redis Ltd. Apache Cassandra is a registered trademark of the Apache Software Foundation. Milvus is a registered trademark of Zilliz. MinIO is a registered trademark of MinIO, Inc. Amazon Redshift and Amazon Aurora are registered trademarks of Amazon.com, Inc. Google Cloud is a registered trademark of Google LLC. Snowflake is a registered trademark of Snowflake Inc. Databricks is a registered trademark of Databricks, Inc. MySQL and InnoDB are registered trademarks of Oracle Corporation. Oracle is a registered trademark of Oracle Corporation. MariaDB is a trademark of MariaDB Corporation Ab. All other trademarks are property of their respective owners. Other product or company names mentioned may be trademarks or trade names of their respective owner. Copyrights © 2010-2025. All Rights Reserved by ChistaDATA®.