Building A Better ClickHouse® for Parquet in Practice

Building A Better ClickHouse® for Parquet in Practice

A few weeks ago we discussed how to read external Parquet data from ClickHouse. The article raised some performance concerns when querying big collections of Parquet files out of AWS S3 buckets. Time flies fast. Altinity engineers have made some…

Building A Better ClickHouse®

Building A Better ClickHouse®

In this article, we give a short retrospective of Altinity contributions to ClickHouse and also introduce our view on how ClickHouse should evolve to be the best database on the planet! 

Math Games in ClickHouse® — Solving Project Euler Problems

Math Games in ClickHouse® — Solving Project Euler Problems

ClickHouse is an extremely versatile DBMS. When presenting it to newbies, I sometimes describe it as a combination of four “F”-s: Fast, Flexible, Fun and Free. We often benchmark ClickHouse in different scenarios to demonstrate how fast it is. Case…

Reading External Parquet Data from ClickHouse®

Reading External Parquet Data from ClickHouse®

ClickHouse support for Apache Parquet is outstanding. We blogged about it last year in “What’s Up With Parquet Performance in ClickHouse”. In this article, we will look at Parquet from a different perspective. Let’s say there is public Parquet data…

2023++

2023++

2023 is almost over. In 2023, it took Altinity plenty of running to keep up the momentum, and we managed to run even faster to discover more opportunities for our users and ourselves. Let’s take a look back and see…

Bring Your Own Cloud for ClickHouse®

Bring Your Own Cloud for ClickHouse®

Altinity.Cloud Anywhere’s innovative Bring Your Own Cloud (BYOC) model offers complete user control of data and simple administration. Learn how to to use Altinity.Cloud in your analytic stack.

The Tournament of AWS CPUs in Altinity.Cloud®

The Tournament of AWS CPUs in Altinity.Cloud®

Dive into our latest blog to explore a rigorous ClickHouse benchmark tournament, featuring AWS’s 7th-gen Intel m7i, AMD m7a, and Graviton m7g instances. With Altinity.Cloud’s easy configuration, discover which instance offers the best price-performance ratio for your cloud operations. Find…

Caching in ClickHouse® – The Definitive Guide Part 1

Caching in ClickHouse® – The Definitive Guide Part 1

In this Part 1 article of our latest series on ClickHouse caches, we break down cache types like query caches that are used to speed up SELECT query processing. Read how caches can increase database system performance and capacity.