Some Notes on Why to Use Clickhouse

In this post I try to justify with my reasons why one should use Clickhouse as a their main OLTP Database for massive analytics work loads with millisecond latency on scanning billions of rows. In…

Filter by Column MySQL vs Clickhouse

Filter by column was a typical business case requirement for reporting or creating analytical dashboards. Even though there are many OLAP databases available in market . In this blog post i will delve deep in…

TPC-DS Benchmark On Clickhouse Part 2

Loading data Into Clickhouse In the previous post I discussed about TPCDS Data generation you can find details here The dataset I’m working with is broken up into 121 .dat files. The data generated by…

TPC-DS Benchmark On Clickhouse Part 1

ClickHouse ClickHouse is an open source, columnar-oriented database that’s been developed primarily by engineers at Yandex. Yandex is one of Europe’s largest Internet-focused businesses. There search engine alone was receiving 150 million searches a day in 2012. ClickHouse…

Clickhouse – Introduction

Introduction Clickhouse is an open source columnar database that has received much attention in recent years and is mainly used in the field of data analysis (OLAP).  Characteristics of OLAP scenarios Read more than write…