Sparse data storage and query patterns in ClickHouse

Amit Sanjay Sadafule, Co-Founder and Head of Technology at Manthhan Softwares

Finding storage schema, for sparse data, that works "well" is tricky. This talk is about exploring the "right" schema to store sparse data in ClickHouse. Speaker will share challenges with sparse data and how ClickHouse helped to achieve the balance between optimized storage and query execution time, with real numbers from testing of different schema options. This talk will help you to explore various options to store the same data in different formats and pros & cons of each approach.

This talk was delivered live at the ClickHouse Pune meetup on September 20, at One2N's office by Amit Sanjay Sadafule, Co-founder and Head of Technology at Manthhan Softwares.

The full agenda can be found at https://www.meetup.com/clickhouse-pune-user-group/events/310644227/