[SUPPORT] Upgrading to 0.11.1 resulting use delete of sparksql

[bigdata-spec]

The environment is CDH6.3.2 and Hudi is 0.11.1

I want to test delete of spark sql，
there are 4 records in the table ，vehicle_model_id is [100 101 102 105]
when I use spark sql run：
delete from zone_test.hudi_spark_table0719_0101 where vehicle_model_id = '102'; it works ok there is 3 records in the table ，

But when I run ：
delete from zone_test.hudi_spark_table0719_0101 where vehicle_model_id = '109'; 109 does‘t exists in the table。

and i query by hive

and i query by trino ，it query normal。

is hudi can't delete not exsits record？

[fengjian428]

seems to be the same issue as #5765 ?

[alexeykudinkin]

@jiangbiao910 i'm not able to reproduce this issue on the latest master with a simple test that i'm putting up in #6318.

Would it be possible for you to check this issue against latest master?

[alexeykudinkin]

Moreover, seems like first stack-trace has occurred in Cleaner not when deleting the record itself (we might need to adjust the title and description)

[nsivabalan]

@jiangbiao910 : can you try w/ 0.12 or latest master and let us know if you are still facing issues.