We are thrilled to be among Percona Live speakers and sponsors once again! Come and meet our team at the Exhibit Hall

Use a special discount code SPaltinity20 to get 20% off registration

Don’t miss ClickHouse presentations:

Oct 1. 6:00 PM – 7:00 PM, Room 08
ClickHouse Features to Blow Your Mind
Speaker: Aleksei Milovidov, Yandex

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;

Oct 2. 10:00 AM – 10:30 AM, Room 07
ClickHouse Materialized Views: A Secret Weapon for High Performance Analytics
Speakers: Robert Hodges, Altinity CEO; Alexander Zaitsev, Altinity CTO

Materialized views are a powerful addition to data warehouses that automatically transform data into new forms and improve query performance by orders of magnitude. ClickHouse has a particularly good implementation. This talk introduces ClickHouse materialized views using standard examples that should be in the toolkit of any data warehouse designer. We start with simple aggregation and extend to time series use cases like the ‘last point problem,’ reclustering data for better performance, and even pulling data from Kafka queues. Through these concrete examples you’ll understand the benefits of materialized views as well as the plumbing that makes them work in large, distributed data warehouses.