Good morning folks, a question regarding MVCC. Whe...
# general
s
Good morning folks, a question regarding MVCC. When an SQL ingestion spec uses
REPLACE <table> OVERWRITE WHERE
and given that my table already has data for a time chunk for which there is no data in my input source(but there is data for other time chunks), then when (1) new segments are build and (2) old segments are deleted (since i dont have data in my input source for some existing time chunk) then: Is the visibility of new segments and deletion of old segments atomic? Or for some time do both old segments(to be deleted) and new segments returns data since deleted segments and new segments are for different time chunks? TLDR, does MVCC apply for data updates or for deletions as well?
r
The updates are atomic. And also the queries will flip seemlessly from old data to new data.