Answer-first summary for fast verification
Answer: VACUUM deletes files that are no longer referenced by the Delta Lake table and are older than the specified retention period, helping to free up storage space.
The VACUUM command in Delta Lake deletes files that are no longer referenced by the Delta Lake table and are older than the specified retention period. This helps to free up storage space. The default retention period is 7 days, but it can be adjusted based on the needs of the system, ensuring that historical data is available for queries that require it.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Describe how the VACUUM command works in Delta Lake and what kind of files it deletes. Explain the implications of using VACUUM with a retention period.
A
VACUUM deletes all files in the table directory, including active and deleted files, and has no retention period.
B
VACUUM compacts small files into larger ones to improve query performance and has a default retention period of 7 days.
C
VACUUM deletes files that are no longer referenced by the Delta Lake table and are older than the specified retention period, helping to free up storage space.
D
VACUUM reorders the data files to optimize storage and has a retention period that can be set to any value.
No comments yet.