v.25.4Improvement
Use insertion columns for INFILE schema inference
Use insertion columns for INFILE schema inference. #78490 (Pervakov Grigorii).
Why it matters
This feature improves schema inference during data loading with INFILE by utilizing the actual columns specified in the insertion query, ensuring more accurate and reliable schema detection compared to previous methods.How to use it
When loading data usingINFILE, the schema inference will automatically consider the columns defined in the INSERT INTO statement. Users do not need to perform any additional configuration; the feature works transparently during data insertion.