zhangshenghang commented on PR #10222: URL: https://github.com/apache/seatunnel/pull/10222#issuecomment-3686598979
> > INSERT → UploadSession (batch insertion into the table during commit) UPDATE_AFTER / DELETE → UpsertStream (real-time insertion into the table) > > Could there be such a problem: When UpsertStream processes an UPDATE, the record written by UploadSession may not yet be visible in the table? > > I’ve considered this case, and I think it would be better to separate it via a configuration (`insert-mode` and `upsert-mode`). By default, `insert-mode` uses UploadSession for insert operations, while in `upsert-mode`, inserts use UpsertStream. For `insert-mode`, it would be good to document this behavior. For `upsert-mode`, it should be clearly noted that a primary key is required. What do you think? Then let's provide a detailed explanation in the document. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
