v.20.3New Feature

JSONEachRowFormat Enhancements for Top-Level Array Cases

Official CH changelog text
JSONEachRowFormat: support special case when objects enclosed in top-level array. #8860 (Kruglov Pavel)
JSONEachRowFormat now supports a special case where objects are enclosed in a top-level array.

Why it matters

This feature addresses the limitation in JSONEachRowFormat by enabling it to correctly parse and process JSON input where multiple objects are wrapped inside a single top-level array. This improves compatibility with JSON data sources structured in this way, enhancing data ingestion flexibility for users.

How to use it

Users can now provide JSON input containing an array of objects when using JSONEachRowFormat. The format will automatically handle the top-level array without requiring additional preprocessing or format changes.

Related resources

PreviousNext