steFaiz opened a new pull request, #8446:
URL: https://github.com/apache/paimon/pull/8446

   ### Purpose
   Parts of: https://github.com/apache/paimon/issues/8322
   
   Supports `DELETE` actions in data evolution merge into:
   Like: 
   ```sql
   MERGE INTO t
   USING s
   ON t.id = s.id
   WHEN MATCHED AND s.op = 'delete' THEN DELETE
   WHEN MATCHED AND s.op = 'update' THEN UPDATE SET t.b = s.new_b
   WHEN NOT MATCHED THEN INSERT (id, b, c) VALUES (s.id, s.new_b, s.new_b + 
1000)
   WHEN NOT MATCHED BY SOURCE AND t.id IN (5, 10) THEN DELETE
   ```
   
   At present, we permit 2 clause branch to perform `DELETE` actions:
   1. `WHEN MATCHED [AND] THEN DELETE`
   2. `WHEN NOT MATCHED BY SOURCE [AND] THEN DELETE`
   
   ### Tests
   See ITcases in:
   `DataEvolutionDeletionTestBase`


-- 
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]

Reply via email to