Explanation:
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.
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.