ClickHouse Blog

November 2018
ClickHouse at Analysys A10 2018
4 November, 09:00

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.

Each year Analysys also organises OLAP contest. Second year in a row the same team of Sundy Li (李本旺) and Winter Zhang (张健) wins it by using ClickHouse as the core of their solution. The task was to calculate complex marketing funnel as fast as possible.

Sundy Li (李本旺) receives award for winning Analysys OLAP contest 2018 from William Kwok (郭炜)

First day of conference we mostly spent talking with people on ClickHouse booth, while on second day there were two technical talks about ClickHouse:

Alexey Milovidov demonstrates ClickHouse and how it works internally
Sundy Li (李本旺) explains the audience how they won the OLAP contest using ClickHouse

The next day after A10 was a dedicated ClickHouse Community Meetup in Beijing, but it deserves a separate recap post.

Analysys A10 afterparty

No comments
events,conference,Beijing,China
ClickHouse Community Meetup in Beijing on October 28, 2018
12 November, 12:00

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.

See the video recording of all talks and all slides.

    Welcome word by William Kwok (郭炜), CTO of Analysys, who played a key role in organizing this event
    Nikolay Kochetov from Yandex demonstrating recent advancements in string processing optimization using LowCardinality feature

    Shang Shujie (尚书杰) from Kuaishou gives an overview of ClickHouse and it's usage scenarios
    Winter Zhang (张健) from QingCloud explains their services based on ClickHouse
    Audience listening to Zhang's talk
    Li Junfei (李俊飞) from Tencent explains how ClickHouse fits their data processing infrastructure
    Questions&Answers session

    Jack Gao (高鹏) from Sina explains their ClickHouse usecase and gives some advice based on their extensive experience with ClickHouse

    Chinese developers are also one of the most active worldwide in contributing to ClickHouse source code compared to other countries. Chinese ClickHouse Contributors Awards 2018 ceremony was also part of meetup agenda with the following 

    1. 张建 (Winter Zhang, zhang2014) received First Place among independent ClickHouse developers in China for 2018, having developed 22 new features, improvements, and fixes in 57 pull requests.
    2. Amos Bird received Second Place among independent ClickHouse developers in China for 2018, having developed 16 new features, improvements, and fixes in 42 pull requests.
    3. 李本旺 (sundy-li) received Third Place among independent ClickHouse developers in China for 2018, having developed 6 new features, improvements, and fixes in 11 pull requests.

    Special award went to William Kwok (郭炜) active role in developing Chinese ClickHouse Community.

    Sundy Li (李本旺) receives ClickHouse Contributor Award from Alexey Milovidov
    William Kwok (郭炜) receives special award for organizing Chinese ClickHouse community and meetups

    Pre-meetup at Analysys office

    No comments
    events,meetup,China,Beijing
    ClickHouse at Percona Live Europe 2018
    today, 12:00

    Opensource database management systems conference Percona Live this time took place 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.

    There were three talks about ClickHouse in agenda, while only one of them was from Yandex. Also we had a lot of interesting conversations with conference attendees at ClickHouse booth sponsored by Altinity.

    Alexander Zaitsev, CTO and co-founder of Altinity, gives an overview of ClickHouse and then demonstrates case studies and best practices (slides).
    Fast! Flexible! Free! Fun!
    Aleksey Milovidov, lead ClickHouse developer from Yandex, talks about unusual and unique ClickHouse features (slides).
    Aleksandar Aleksandrov and Felix Mattrat, data engineers from MessageBird, show how they use ClickHouse to analyze process of delivery of SMS and other kinds of messages (slides).
    Live demo at ClickHouse booth by Alexey Milovidov.

    No comments
    events,conference,Percona Live,Europe,Frankfurt,Germany