Hudi experts and Users, Has anyone attempted an upsert after a delete? Here is a weird thing that I have bumped into and it is a shame that this has come up when someone in the team tested this whilst I failed to run this test. Use case: Insert data into a table. Say records (1, kabeer | 2, vinoth)
Delete a record (1, kabeer). Data in the table is: (2, vinoth) and it is visible via sql through Presto/Hive. Upsert a new record into the same table (3, balaji). Query the table and only record that is visible is: (3, balaji). The record (2, vinoth) is not displayed in the results. Any ideas on what could be at play here? Has someone done upsert after delete? Thanks, Kabeer PS: Please note that upsert functionality is well tested and if we do (1, vinoth) insert followed by upsert of (2, balaji) both the records are visible. So something else is at play and would appreciate any help that you experts can provide insight.
