ClickHouse Blog

ClickHouse Community Meetup in Beijing on January 27, 2018

8 February 2018, 20:24

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.

Welcome word by William Kwok, CTO of Analysys, who personally played a huge role in making this event possible.

It was probably the most intense ClickHouse Meetup compared to all previous ones worldwide. The main part of event took over 6 hours non-stop and there were also either pre-meetup and after-party on the same day. Well over 150 people have shown up on Saturday to participate.

Audience listening for ClickHouse introduction by Alexey Milovidov.

Alexey Milovidov have started the main meetup session with introductory talk about ClickHouse, it's usage inside Yandex and history that lead to becoming an open source analytical DBMS.  Slides.

Alexander Zaitsev's practical talk about migrating to ClickHouse.

Alexander Zaitsev have shared his vast experience in migrating to ClickHouse. LifeStreet, advertisement company where he works, was one of the first companies outside of Yandex which switched to ClickHouse from other analytical DBMS in production. Later on Alexander also co-founded Altinity, a company which specialises  on helping others to migrate to ClickHouse and then effectively use it to achieve their business goals. The talk have covered many specific topics that are important for those who are in the middle of such migration or just considering it. Slides.

Alexey Zatelepin explaining how ClickHouse sparse index works and other implementation details.

Alexey Zatelepin's technical talk was focused on providing engineers some insights on why ClickHouse is that fast in OLAP workloads and how to leverage it's design and core features like primary index, replication and distributed tables to achieve great performance and reliability. Slides.

Jack Gao gives an extensive overview of ClickHouse and it's use cases in Chinese.

As we have learned during meet up and the rest our business trip, actually there are many companies in China which are already using or seriously evaluating ClickHouse to use either part of their products or for internal analytics. Three of them are doing this long and extensively enough to give a full talk about their progress and experience.

In China in general and especially in Beijing the knowledge of English is not really common. Chinese people working in IT industry have to know English well enough to read documentation, but it does not really imply that they can talk or understand verbal English well. So the talks by representatives of local companies were in Chinese.

Jack Gao, ex-DBA and now analyst at Sina (major social network), have dedicated a significant part of his talk to go over fundamental topics essential to most ClickHouse users. It partially overlapped with previous talks, but this time in Chinese. Also he covered not only use case of ClickHouse in Sina, but also other publicly known cases by other companies. Considering the reaction of the audience, it has been the most useful talk of the whole meetup, because of the widely useful content, lack of language barrier and excellent execution of presentation. We even had to sacrifice initially scheduled short break to give Jack some additional time. Slides.

Yang Xujun from Dataliance/UltraPower, which provides outsourced data analysis platform to telecom companies in China, have demonstrated why they decided to move away from reports prepared offline in Apache Hadoop / Spark and exported to MySQL towards ClickHouse. In short: Hadoop is too slow and cumbersome. Slides.

It might sound obvious, but huge Chinese population generates insane amounts of data to store and process. So IT companies operating mostly on local Chinese market are often handling amounts of information comparable to even the largest global companies.

Kent Wang from Splunk Shanghai R&D center have demonstrated current state of ClickHouse integration into Splunk ecosystem.  Basically they have plugged ClickHouse into their system via JDBC driver to allow data from ClickHouse to be easily accessed in Splunk UI and dashboards. Last spring Yandex ClickHouse team actually had a friendly visit to Splunk office in San Francisco to discuss potential points of interaction and exchange experience, so it was great to hear that there's some real progress in that direction. Slides.

The last talk was for the most tenacious ClickHouse users. Alexey Milovidov have announced some recently released features and improvements and shared what's coming next either in short and long term. Slides.

There's an over 5 hours long video recording of main meetup session, but it'll take a bit of effort to get access to it (especially if you are not from China):

  1. You'll need to install WeChat (probably one of the most popular messengers in the world, everyone in China has it) on your smartphone: Android or iOS.
  2. On first launch WeChat will ask to confirm your phone number via SMS, read some digits via microphone and accept user agreement. Go through this.
  3. On your computer, click the red button in the middle of video behind the link above. It'll show a QR code. Now in WeChat in top-right corner there's “+” button which opens menu that has “Scan QR code” item. Use it to scan QR code from your computer screen, then press the “Sign in” button on smartphone. Now the video on computer automatically becomes playable.

If you are from China or at least can read Chinese, you might consider joining the Chinese ClickHouse User Group.

Pre-meetup meeting of speakers and most active ClickHouse users in China.
ClickHouse Community Meetup afterparty.