v.22.4Experimental Feature

Support Schema Inference for Object Type in JSONEachRow Format

Official CH changelog text
Support schema inference for type Object in format JSONEachRow. Allow to convert columns of type Map to columns of type Object. #35629 (Anton Popov).
Support schema inference for the Object data type in the JSONEachRow input format and enable conversion from Map columns to Object columns.

Why it matters

This feature allows ClickHouse to automatically detect and infer schemas containing the Object type when importing data with the JSONEachRow format. Additionally, it makes it possible to convert existing Map type columns to the more versatile Object type, enhancing flexibility in handling nested or semi-structured data.

How to use it

Simply use the JSONEachRow format when importing data that includes Object-typed fields to benefit from schema inference. To convert a column from Map type to Object type, utilize appropriate ALTER TABLE commands or cast operations within queries.

Related resources

PreviousNext