rohityadav1993 opened a new issue, #13140: URL: https://github.com/apache/pinot/issues/13140
`bug` We are observing that during segment commits, there is a situation in the new segment where instead of merging the row for an existing PK it is getting added as a new row, loosing all the mergers that happened. Build: Pinot version: 1 Included patches to attempt a fix: #12395 #12241 #12105 Possible know factors to reproduce: 1. High ingestion scale: 15k msg/sec 2. Use a constant value for comparisonColumn 3. Any partial upsert merger, easier to observe in append list. Query for testing: ``` select test_list, $segmentName, $docId from rta_test_table where pk = '2dc705af-b8e9-4e55-a483-1cc64a7002e7' -- and $hostName = 'host1' and $hostName = 'host2' order by $segmentName, $docId limit 100 option(skipUpsert=true) ``` diff: <img width="839" alt="image" src="https://github.com/apache/pinot/assets/12524914/5f3d2f3f-106f-41ed-a906-3f268305f566";> -- 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]
