Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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.
