Jan 8, 2018
ClickHouse development team is known for lack of published development plans. Sometimes they disclose plans responding to questions and bug reports, but more often discuss the roadmap at meetups. In this article we describe 'secret' 2018 roadmap that has been presented at ClickHouse Meetup in Moscow on December 12th by Alexey Milovidov.
Jan 8, 2018
Jan 4, 2018
It's been a while since Altinity announced a partnership with Kodiak Data, a cloud-infrastructure company. Despite that, we have never written about Kodiak Data and how they help with ClickHouse deployments. Now there are several companies already using ClickHouse at Kodiak Data MemCloud(TM), so it's time to explain why. In this article, we test ClickHouse performance at various AWS and Kodiak Data cloud instances as well as add RedShift to complete the picture.
Dec 18, 2017
There are many cases where ClickHouse is a good or even the best solution for storing analytics data. One common example is web servers logs processing. In this article, we guide you through Nginx web server example but it is applicable to other web servers as well.
We will use Logstash with ClickHouse in order to process web logs. Logstash is a commonly used tool for parsing different kinds of logs and putting them somewhere else. For example, in ClickHouse. This solution is a part of Altinity Demo ApplianceRead More
Dec 6, 2017
Christian Hotz-Behofsits, Teaching & Research Associate at Vienna University of Business and Economics, is one of the creators of RClickhouse package for R that we have recently introduced on our blog. In this article he describes data analysis challenges his group is facing and how ClickHouse helps in their research.
Dec 5, 2017
Altinity has developed an open source clickhouse-mysql tool that helps to migrate existing MySQL table to ClickHouse and setup realtime replication of changes (INSERTS only). Here we review necessary steps using a simple example.
Nov 29, 2017
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.
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?
Nov 21, 2017
It might not be obvious from the start, but ClickHouse supports different kinds of compressions, namely two LZ4 and ZSTD.
Nov 8, 2017
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
Nov 6, 2017
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
Oct 23, 2017
ClickHouse is an excellent analytics database choice not just for startups but also for companies that have already invested significant amount of resources into their analytics solutions, but are not completely satisfied with the results. In this article we will discuss how and when companies consider the ClickHouse migration project, and what challenges they may expect. We do not disclose any names, but every example has a real world prototype.
Oct 5, 2017
In this blog, I'll use ClickHouse and Tabix to look at a new very large dataset for research.
It is an interesting dataset I found recently that has been available since 2015. This is Reddit's comments and submissions dataset, made possible thanks to Reddit's generous API.Read More
Sept 13, 2017
In this blog, I’ll look at how to use ClickHouse for parallel log processing. Below I’ll show how ClickHouse can be used to efficiently perform this task. ClickHouse is attractive because it has multi-core parallel query processing
Aug 30, 2017
It took a while for Yandex to respond to numerous community requests regarding release notes. But finally it's there. On August 21-st Yandex created a changelog file covering releases starting from 1.1.54245, and they keep it up to date so far.
Aug 30, 2017
In this blog post, we’ll look at nested data structures in ClickHouse for MySQL and how this can be used with PMM to look at queries.
Aug 21, 2017
Altinity announced that it will provide a cloud version of ClickHouse on Kodiak Data MemCloudTM, the edge-cloud for Big Data.