v.23.3Improvement

Allow Types Conversion in Native Input Format with New Setting

Allow types conversion in Native input format. Add settings input_format_native_allow_types_conversion that controls it (enabled by default). #46990 (Kruglov Pavel).
Allow automatic types conversion when reading data in the Native input format in ClickHouse.

Why it matters

This feature solves the problem of strict type matching when importing data with the Native input format by enabling seamless conversion between compatible data types. It improves usability and flexibility, allowing users to load data without manual type adjustments or conversions, which simplifies data ingestion workflows.

How to use it

The feature is controlled by the setting input_format_native_allow_types_conversion, which is enabled by default. Users can disable or enable this behavior by setting this parameter in their session or configuration file.