Nested Types
Nested types allow embedding complex objects within table rows. Nested types store each field as a separate array column, which can impact query performance for high-throughput paths. Consider Named Tuples for simpler structures stored inline.
Usage
Define a separate model and use it as a field type.
interface Address { street: string; city: string; zip: string; country: string;} interface User { name: string; email: string; address: Address; // Nested type}Multiple Levels
Nested types can contain other nested types.
interface Coordinates { lat: number; lng: number;} interface Address { street: string; city: string; location: Coordinates; // Nested within nested} interface User { name: string; address: Address;}Nested vs JSON
Use nested types when the structure is known and fixed. Use JSON for dynamic or variable structures.
See Also
- Tuples — Lightweight inline structured data
- JSON — Dynamic or semi-structured data
- ClickHouse Nested — ClickHouse official documentation