Reinvent JSON Storage: How we Built New Powerful JSON Data Type for ClickHouse – Robert Schulze, ClickHouse

Session Outline

JSON has become the lingua franca for handling semi structured and unstructured data in modern systems, powering everything from logging and observability to real-time streaming, mobile app storage, and machine learning pipelines. Its flexibility makes it the default choice for capturing and transmitting data across distributed environments. In this talk, we’ll share how we completely reimagined JSON storage on top of column-oriented storage. The result: unmatched speed, compression, and user experience—far beyond any existing JSON data store. As far as we can tell, this is the first time columnar storage has been implemented the right way for semi-structured data, unlocking performance gains never seen before.

Key Takeaways

  • How to achieve true columnar JSON storage that is even more compact than compressed files on disk.
  • Why this approach is thousands of times faster than traditional JSON data stores.
  • How it fully supports dynamically changing JSON paths without forcing unification into a least common type.
Add a comment

Leave a Reply