v.23.5New Feature

Added input_format_csv_trim_whitespaces option

Added --input_format_csv_trim_whitespaces option. #50215 (Alexey Gerasimchuk).
Added the --input_format_csv_trim_whitespaces option to control trimming of whitespaces in CSV input format.

Why it matters

This feature allows users to trim whitespaces around values when reading CSV data, solving issues with unwanted leading or trailing spaces that can affect data parsing and integrity.

How to use it

Enable the feature by using the --input_format_csv_trim_whitespaces option when importing CSV data to automatically trim whitespaces around fields.