hudi_time_travel.sql

-- first update (birth)
UPDATE public.artists
SET birth_year = 1907
WHERE artist_id = 299;

-- second update (death)
UPDATE public.artists
SET death_year = 1989
WHERE artist_id = 299;

-- third update (middle initial)
UPDATE public.artists
SET name = 'Gerhard M. Bakker'
WHERE artist_id = 299;

-- fourth update (nationality - impacts partitions)
UPDATE public.artists
SET nationality = 'German'
WHERE artist_id = 299;

-- fifth update (birth)
UPDATE public.artists
SET birth_year = 1905
WHERE artist_id = 299;

-- delete
DELETE
FROM public.artists
WHERE artist_id = 299;