Sounds like you’re hitting the same issues as we did. See Issues with equality deletes in 25.0.0 - and 25.1.0 (hadoop catalog)
Dremio doesn’t support reading table with equality deletes. It is still an issue in 25.2.0. If you do a full rewrite on the table after each update it works, but that’s not really a viable option.
Append only tables written by the connector works though.