v.24.5Experimental Feature
Implement Experimental Dynamic Data Type in ClickHouse
ImplementDynamicdata type that allows to store values of any type inside it without knowing all of them in advance.Dynamictype is available under a settingallow_experimental_dynamic_type. Reference: #54864. #63058 (Kruglov Pavel).
Why it matters
This feature addresses the challenge of handling heterogeneous or schema-less data by allowing users to store and manipulate values of varying types within a single column. It provides flexibility when the exact data types are not known in advance, simplifying ingestion and processing of dynamic data.How to use it
Enable the feature by settingallow_experimental_dynamic_type to 1. Then, define columns using the Dynamic type and use standard SQL queries to insert and retrieve data of any type.