Answer-first summary for fast verification
Answer: Both `year` and `month` columns will be inferred as the partition columns.
The provided path includes two columns (`year` and `month`) for partitioning. Auto Loader is capable of inferring both columns as partition columns. For more details, refer to the documentation on partition inference in Auto Loader.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Given the source path for an Auto Loader is set as s3://records/year=2023/month=11/season1.parquet, which of the following statements accurately describes the partitioning details inferred from this path?
A
The year column will be inferred as the partition column, as Auto Loader supports partitioning only on one column.
B
The month column will be inferred as the partition column, as Auto Loader supports partitioning only on one column.
C
Auto Loader does not support partitioning inference, hence no column will be selected as a partition column.
D
Both year and month columns will be inferred as the partition columns.
E
A new column named year_month will be created for partitioning.
No comments yet.