Answer-first summary for fast verification
Answer: MERGE supports conditional updates and inserts, ensuring data integrity without full table operations.
The MERGE command offers the advantage of conditional operations, meaning it can update existing records and insert new ones based on specified conditions, without requiring a full table overwrite or recreation. This makes MERGE more efficient and suitable for maintaining data integrity in scenarios with frequent updates and inserts.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
In the context of incremental data processing, explain the benefits of using the MERGE command over other SQL commands like INSERT OVERWRITE or CREATE OR REPLACE TABLE. Provide a detailed comparison highlighting the advantages of MERGE.
A
MERGE allows for atomic operations and schema evolution, unlike INSERT OVERWRITE.
B
MERGE supports conditional updates and inserts, ensuring data integrity without full table operations.
C
MERGE is faster than CREATE OR REPLACE TABLE for large datasets.
D
MERGE can handle complex transformations directly in the database.
No comments yet.