object_shared_* MergeTree table settings

These settings are available in system.merge_tree_settings and are autogenerated from ClickHouse source.

object_shared_data_buckets_for_compact_part

The number of buckets for JSON shared data serialization in Compact parts. Works with map_with_buckets and advanced shared data serializations. The maximum allowed value is 256.

object_shared_data_buckets_for_wide_part

The number of buckets for JSON shared data serialization in Wide parts. Works with map_with_buckets and advanced shared data serializations. The maximum allowed value is 256.

object_shared_data_serialization_version

Serialization version for shared data inside JSON data type.

Possible values:

• map - store shared data as Map(String, String)
• map_with_buckets - store shared data as several separate Map(String, String) columns. Using buckets improves reading individual paths from shared data.
• advanced - special serialization of shared data designed to significantly improve reading of individual paths from shared data. Note that this serialization increases the shared data storage size on disk because we store a lot of additional information.

The number of buckets for map_with_buckets and advanced serializations is determined by settings object_shared_data_buckets_for_compact_part/object_shared_data_buckets_for_wide_part.

object_shared_data_serialization_version_for_zero_level_parts

This setting allows to specify different serialization version of the shared data inside JSON type for zero level parts that are created during inserts. It’s recommended not to use advanced shared data serialization for zero level parts because it can increase the insertion time significantly.