Clickhouse Features to Blow your Mind

Thursday 11:55 AM - 12:45 PM

@ Texas 6

Open Source Databases

50 minutes conference


Other OSDB

I will present a subset of the most notable ClickHouse features over the last half of year:
- data skipping indices, including full text indices (with performance evaluation and insights on implementation);
- custom compression codecs for time series data;
- HDFS and Parquet integration;
- fuzzy string search (it is really fast fuzzy string search); multiple substring matching;
- sampling profiler on the query level;
- z-curve indexing;
- table and columns TTL;


Aleksei Milovidov

Aleksei Milovidov (Yandex)

Team Lead


- Moscow State Unversity, department of Mechanics and Mathematics - specialist degree, mathematician (2003-2008);

Yandex LLC (2008-now):
- head of ClickHouse development team (2015-now) (;
- head of Yandex Metrica engine development team (2012-2015) (;
- senior software developer of Yandex Metrica engine (2010-2012);
- software developer of Yandex Metrica engine (2008-2010);

Since 2008 I was working on development of data processing pipeline of Yandex Metrica - web analytics system.
Since 2015 I am responsible for development of ClickHouse - open-source column-oriented database management system, used for realtime analytical reports (
I have 11 years experience with development of specialized data structures using C++ programming language.


Please sign in for 15 day access

Connect with Percona

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@)
  • +1-888-401-3401
  • +1-919-948-2863