Altinity Blog

ClickHouse and R language

Recently Institute for Interactive Marketing and Social Media research team released ClickHouse library for R language. R is a popular language and environment for statistical analysis and visualization. In this article, we try this library by ourselves by a simple example.

Read More
ClickHouse Primary Keys

Nov 27, 2017
In this tutorial, our guest blogger Yegor Andreenko (@f1yegor) is talking about The ClickHouse Primary keys.

  • How many columns could primary key have? And what is a layout of data on storage drive? Are there any theoretical/practical limits?
  • Could columns with missing data at some rows be part of the primary key?

Read More
Compression in ClickHouse

It might not be obvious from the start, but ClickHouse supports different kinds of compressions, namely two LZ4 and ZSTD.

Read More
Custom partitioning in ClickHouse 1.1.54310

ClickHouse introduced a new major feature in version 1.1.54310 - it is a custom partitioning for tables with MergeTree engine. Before it enforced to use Date field for partitioning and the only choice to partition by month.

The new version allows much more flexibility and we can choose the partition schema not only based on Date fields.

Read More
ClickHouse Digest #1

Activity in and around ClickHouse has dramatically increased recent weeks. Percona Live in Dublin, meetups in Bay Area and Berlin, new features, many new companies adopting ClickHouse -- all that generate a lot of news and increase interest to ClickHouse further.

In this article I would like to highlight some ClickHouse recent news. Eventually we plan to publish a monthly ClickHouse news digest, so this is a test ball.

Read More
ClickHouse release 1.1.54310

  The new deb packages are available from Yandex repo and RPMs from Altinity repo. New features: Custom partitioning key for the MergeTree family of table engines. Kafka table engine. Added support for loading CatBoost[...]

Read More