[Feature] Support deleting rows in partial update of specific sequence group

[liyubin117]

Search before asking

• [X] I searched in the issues and found nothing similar.

Motivation

For retract type data in partial update, Paimon have provided three solutions, These three solutions are mutually exclusive and do not take effect at the same time.

1. ignoreDelete to ignore retraction
2. leave fields in sequence group blank
3. removeRecordOnDelete to delete the entire record.

we currently use the partialUpdate+sequenceGroup solution to replace the left join to improve performance, but the delete of the main upstream will not delete the final result, resulting in deviation from the correct result.

Solution

Modify PartialUpdateMergeFunction

Anything else?

No response

Are you willing to submit a PR?

• [X] I'm willing to submit a PR!