v.24.5New Feature

User Can Now Parse CRLF with TSV Format via New Setting

User can now parse CRLF with TSV format using a setting input_format_tsv_crlf_end_of_line. Closes #56257. #59747 (Shaun Struwig).
Added support for parsing CRLF (\r\n) line endings in the TSV input format using the new setting input_format_tsv_crlf_end_of_line.

Why it matters

This feature addresses the issue of TSV files that use Windows-style CRLF line endings, enabling users to correctly parse such files without errors or manual preprocessing, improving compatibility and ease of data ingestion.

How to use it

Enable the feature by setting input_format_tsv_crlf_end_of_line = 1 before parsing TSV data that contains CRLF line endings. This can be done via the session settings or as a query-level setting.