Handling Variable Time Series Efficiently in ClickHouse

Handling Variable Time Series Efficiently in ClickHouse

May 23, 2019ClickHouse offers incredible flexibility to solve almost any business problem in a multiple of ways. Schema design plays a major role in this. For our recent benchmarking using the Time Series Benchmark Suite (TSBS) we replicated TimescaleDB schema…

A Magical Mystery Tour of the LowCardinality Data Type

A Magical Mystery Tour of the LowCardinality Data Type

Mar 27, 2019Many ClickHouse features like LowCardinality data type seem mysterious to new users.  ClickHouse often deviates from standard SQL and many data types and operations do not even exist in other data warehouses. The key to understanding is that…