v.23.12New Feature

Add CSV Setting to Infer Numbers from Strings

Official CH changelog text
Add new setting input_format_csv_try_infer_numbers_from_strings that allows to infer numbers from strings in CSV format. Closes #56455. #56859 (Kruglov Pavel).
Added a new setting input_format_csv_try_infer_numbers_from_strings that enables automatic inference of numeric values from strings when importing CSV data.

Why it matters

This feature addresses the issue of numeric data being imported as strings from CSV files, improving data type accuracy and reducing the need for manual type casting by users.

How to use it

To enable this feature, set the input_format_csv_try_infer_numbers_from_strings setting to 1 before importing CSV data. For example:

SET input_format_csv_try_infer_numbers_from_strings = 1;
-- Then proceed with the CSV import

Related resources

PreviousNext