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).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 settinginput_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.