v.19.7New Features
For Tsvwithnames/csvwithnames Input File Formats, Column Order Can Now Be Determined from File Header
For TSVWithNames/CSVWithNames input file formats, column order can now be determined from file header. This is controlled by input_format_with_names_use_header parameter. #5081 (Alexander)Why it matters
This feature addresses the limitation where users had to rely on predefined column order when importing data in TSVWithNames or CSVWithNames formats. By enabling automatic detection of column order from the file header, it simplifies data ingestion and reduces errors caused by mismatched column orders.How to use it
Set theinput_format_with_names_use_header parameter to true when importing data in TSVWithNames or CSVWithNames format to enable using the file header for column order determination.