ClickHouse Meetup in Beijing
Introduction
Why do we need ClickHouse?
— interactive analytic queries;
— on constantly appended data.
«Double realtime»
The most valuable feature of ClickHouse — it's speed.
Our goals as ClickHouse developers
1. Development and support for use cases in our company (Yandex).
2. Maximum widespread of ClickHouse as open-source product.
Goal: widespread as open-source product
Rules of successful open-source:
— the product must solve actual problem;
— and do it better than others.
Our goal:
ClickHouse must be the default choice
as an open-source analytical DBMS
— the first and the only right solution
for appropriate use cases;
— and everyone should be aware of it :)
Two years in open-source
No time to celebrate.
Two years in open-source
YoY growth: 1.94 total
but 5.05 in China!
— website traffic
Year over Year growth
YoY growth: 1.94 total
but 5.05 in China!
— website traffic
Notable users
Web/App Analytics
Adv Networks
E-Commerce
Telecom
Social
News
Monitoring/Telemetry
Banking/Finance
Government
Adult
Online Games
Info Sec
Agriculture
Blockchain
— VK;
— nVidia;
— Spotify;
— Yandex;
— Amadeus;
— Bloomberg;
— CloudFlare;
— ContentSquare;
— Deutsche Bank;
— A-word fruit company;
— C-word telecom company;
— e-word ecommerce company;
— National payment system of (undisclosed) country.
Meetups & Conferences
| | 2016 | 2017 | 2018 |
| Russia | 6 | 18 | 7 |
| Europe | 1 | 4 | 3 |
| USA | - | 2 | 3 |
| Asia | - | - | 3 |
Rough Roadmap for Q4-Q1
Improvement of SQL dialect, full support for JOIN:
— multiple JOINs without subqueries;
Workload management:
— fair resource sharing between queries;
Fine grained user access control:
— ACL, RBAC, LDAP...
Advantages of open-source
— better product quality;
— better Yandex representation as tech company;
— for hiring developers more easily;
— motivation of developers;
Drawbacks:
— it's hard work;
— and we're working really a lot;
