Answer-first summary for fast verification
Answer: The `readerCaseSensitive` option should be set to `false`
The correct answer is to set the `readerCaseSensitive` option to `false` to enable case-insensitive inference of column names. By default, this option is set to `true` in 'rescue' mode, making the inference case-sensitive. The `readerCaseInsensitive` option is invalid. This functionality is applicable to AVRO, Parquet, and CSV files.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
To enable case-insensitive behavior of column names in an Auto Loader pipeline while iteratively reading Parquet files from an S3 location with schema evolution mode set to 'rescue', which property should be adjusted?
A
The readerCaseSensitive option should be set to true
B
No adjustments are needed as column names in Auto Loader are always inferred case-insensitively in 'rescue' mode.
C
The readerCaseSensitive option should be set to false
D
The readerCaseInsensitive option should be set to true
E
The readerCaseInsensitive option should be set to false
No comments yet.