PedroMDuarte opened a new issue, #17001: URL: https://github.com/apache/iceberg/issues/17001
### Apache Iceberg version 1.11.0 (latest release) ### Query engine Spark ### Please describe the bug 🐞 When streaming from a table that's compacted (appends interleaved with replace snapshots, `streaming-skip-overwrite-snapshots=true`), each micro-batch reads fewer rows than the configured limit allows, and a restart can produce duplicate rows. While working on a large scale streaming job we found a few related bugs in the sync/async micro batch planners (spark/v3.5): 1. Skipped snapshots count against the limit. Files in a replace snapshot are counted against the limit, but then planning skips them. The batch ends up smaller than the limit allows. 2. When row limit is unset the value is treated as Integer.MAX_VALUE. Setting only a file limit caps each microbatch at ~2,147,483,647 rows. The counters are also int which causes overflows for large row numbers. 3. The async planner fills treats the start snapshot differently in `fillQueue(Snapshot readFrom)` and `fillQueue(fromOffset, toOffset)`. The read from version applies shouldProcess and skips replace/overwrite/delete. The from offset enqueues the start snapshot. This could be a compaction snapshot so re-reads the rewritten files. In practice the batch planner will not commit an offset inside a non-append snapshot, so this is hard to hit. But it is better to apply the same skip check defensively. Expected behavior * Only append snapshots contribute to the rows/files limit. replace/overwrite/delete are skipped. * A single micro-batch can span multiple appends and cross intervening replace snapshots to reach the configured streaming-max-files-per-micro-batch / streaming-max-rows-per-micro-batch, counting only appended rows. * A files-only or unbounded row limit is genuinely unbounded. * A restart never re-reads already-delivered rows. ### Willingness to contribute - [x] I can contribute a fix for this bug independently - [ ] I would be willing to contribute a fix for this bug with guidance from the Iceberg community - [ ] I cannot contribute a fix for this bug at this time -- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
