ClickHouse Blog

Concept: "Cloud" MergeTree Tables

The main property of the MergeTree cloud tables is the absence of manual control over the sharding scheme of data on a cluster. The data in the cloud tables is distributed around the cluster on its own, while at the same time providing the locality property for a certain key.

Read more
No comments
concept,MergeTree,future,sharding
ClickHouse Meetup in Amsterdam on November 15, 2018

20th ClickHouse Meetup took place in Amsterdam, which appeared to be a convenient location for people from all over Europe to join the event, including Austria, Czech Republic and Germany. We were also glad to see people from many local companies including Booking.com, Crobox, Marktplaats (eBay), MessageBird and others.

Read more
No comments
meetup,Amsterdam,Netherlands,events
ClickHouse at Percona Live Europe 2018

Opensource database management systems conference Percona Live this time took place on November 5-7 in Germany, Frankfurt am Main. Over last couple years ClickHouse became a solid member of this community as demand in analytics with subsecond latencies appeared to be pretty high.

Read more
No comments
events,conference,Percona Live,Europe,Frankfurt,Germany
ClickHouse Community Meetup in Beijing on October 28, 2018

Interest in ClickHouse among Chinese experts is growing rapidly. It was second ClickHouse Meetup in Beijing this year and the venue was more than full, it could fit only about 170 people out of 500 who signed up and around 2000 more joined the live translation online. Many  Chinese companies have already adopted ClickHouse in production and are willing to share their experience.

Read more
No comments
events,meetup,China,Beijing
ClickHouse at Analysys A10 2018

Analysys A10 is a large conference on Big Data that took place on October 26-27 in Beijing. Since China's population is huge, it generates a lot of data and Big Data industry is in very high demand. Yandex ClickHouse team has been honored to participate in this event alongside top management, analysts and IT professionals from various Chinese companies.

Read more
No comments
events,conference,Beijing,China
Announcing ClickHouse Meetup in Amsterdam on November 15

Yet another meetup of ClickHouse community is planned in Europe, see detailed agenda and register on the event page.

Read more
No comments
ClickHouse Community Meetup in Paris on October 2, 2018

Agenda of Paris ClickHouse Meetup was full of use cases, mostly from France-based companies which are actively using ClickHouse. Slides for all talks are available on GitHub.

Read more
No comments
meetup,events,Paris,France,Europe
ClickHouse Community Meetup in Berlin on July 3, 2018

Just few month ago Brenno Oliveira from Delivery Hero have dropped us an email on clickhouse-feedback@yandex-team.com saying that they want to host a meetup of ClickHouse community in their HQ and together we made it happen.

Read more
No comments
Berlin,meetup,Europe,events
Announcing ClickHouse Community Meetup in Berlin on July 3

There's yet another upcoming meetup of ClickHouse community in Europe, see detailed agenda and sign up on the event page.

Read more
No comments
meetup,Berlin,Europe
ClickHouse Community Meetup in Beijing on January 27, 2018

Last year there has been an OLAP algorithm contest in China organised by Analysys. The team who have shown the top results and won the competition has been using ClickHouse as core of their solution. Other teams were mostly using different technologies and didn't really know much about ClickHouse at a time. When the final results were published, many people in China who participated in or were aware of this competition became really eager to learn more about ClickHouse. This spike of interest about ClickHouse in China have eventually lead to first Chinese ClickHouse Community Meetup that have taken place in Beijing.

Read more
No comments
events,meetup,China,Beijing
ClickHouse Meetup at Berlin, October 5, 2017

All presentations are available for download at the event page.

Read more
No comments
meetup,Berlin,events
Join the ClickHouse Meetup in Berlin

Come learn about ClickHouse, our open source high-performance column-oriented database management system at a meetup on October 5, 2017 at the Park Inn at Alexanderplatz 7 in Berlin.

ClickHouse can generate custom data reports in real time and process billions of rows and dozens of gigabytes of data per single server per second. It works up to a thousand times faster than traditional approaches. ClickHouse is linearly scalable, hardware-efficient, fault-tolerant, and can be deployed across multiple data centers.  Among other features, ClickHouse offers a user-friendly SQL query dialect with a number of built-in analytics capabilities.

Join us at the meetup to learn why hundreds of companies across Europe, US, and China are adopting ClickHouse. Through interactive talks, attendees will learn about product features, how ClickHouse can benefit them, and how to use this system in practice.
Attending the ClickHouse meetup is free. Please register to join us.

Read more
No comments
events,announcement,Berlin,Europe,2017
ClickHouse at Data@Scale 2017

Slides

Read more
No comments
events,conference,Percona Live,Seattle
ClickHouse Meetup at Santa Clara, May 4, 2017

After Percona Live 2017, Yandex ClickHouse team stayed for one more week in San Francisco Bay Area to meet with local companies in person to talk about ClickHouse and how it can be applied to their tasks. On the last evening we even managed to organize our own meetup with active ClickHouse users in the area, not as large as we regularly host in Russia, but still had some very interesting discussions.

Read more
No comments
events,meetup,Bay Area
ClickHouse at Percona Live 2017

For those who haven't heard, Percona Live is probably one of the largest international conferences about opensource database management systems, having 12 talk tracks in parallel. It's been around for many years and initially it was focused mainly on MySQL (and had that in it's name), but nowadays it is more generic and other products of this category get lots of attention too. Needless to say that for a relatively new player on the market like ClickHouse, it's been a great opportunity to spread the word about the technology and how exactly it allows to perform analytics on petabytes of data in real time.

Read more
No comments
events,conference,Percona Live,Bay Area,Graphouse
Evolution of Data Structures in Yandex.Metrica

Yandex.Metrica takes in a stream of data representing events that took place on sites or on apps. Our task is to keep this data and present it in an analyzable form. The real challenge lies in trying to determine what form the processed results should be saved in so that they are easy to work with. During the development process, we had to completely change our approach to data storage organization several times. We started with MyISAM tables, then used LSM-trees and eventually came up with column-oriented database, ClickHouse.

Read more
No comments
Yandex.Metrica,data structures,LSM tree,columnar storage
How to Update Data in ClickHouse

There is no UPDATE or DELETE commands in ClickHouse at the moment. And that's not because we have some religious believes. ClickHouse is performance-oriented system; and data modifications are hard to store and process optimally in terms of performance.

Read more
3 comments
features,update,delete,CollapsingMergeTree,partitions
Yandex Opensources ClickHouse
Read more
No comments
announcement