noob-se7en opened a new pull request, #16067: URL: https://github.com/apache/pinot/pull/16067
**Problem Statement:** 1. In Pauseless + Dedup, For fixing bad segment using `/deleteSegmentsFromSequenceNum/{tableNameWithType}` API, manual work is required to fetch segment with lowest sequence number per partition group. 2. Currently some users use a script to get bad segments for fixing the table (non pause-less tables as well). **PR:** This PR adds an API to Get a sorted list of bad segments per partition group (sort order is in increasing order of segment sequence number) for the input table. **Sample Request:** <img width="1470" alt="Screenshot 2025-06-11 at 2 04 55 AM" src="https://github.com/user-attachments/assets/79c796cc-dcdb-49e1-ab28-a9b719a7562d" /> **Sample Response:** <img width="1460" alt="Screenshot 2025-06-11 at 2 05 28 AM" src="https://github.com/user-attachments/assets/bfc2db9f-2f8e-4a68-abca-bb17a8a3825c" /> -- 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: commits-unsubscr...@pinot.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For additional commands, e-mail: commits-h...@pinot.apache.org